16.20 - Example: FORMAT Phrase - Teradata Vantage NewSQL Engine

Teradata Vantage™ Data Types and Literals

prodname

Teradata Database

Teradata Vantage NewSQL Engine

vrm_release

16.20

created_date

March 2019

category

Programming Reference

featnum

B035-1143-162K

This query returns the value '15h33m'.

SELECT CAST('15h33m'
AS TIME(0) FORMAT 'HHhMIm');