17.10 - Example: FORMAT Phrase - Advanced SQL Engine

17.10 - Example: FORMAT Phrase - Advanced SQL Engine - Teradata Database

Teradata Vantage™ - Data Types and Literals

Product

Advanced SQL Engine

Teradata Database

Release Number

17.10

Release Date

July 2021

Content Type

Programming Reference

Publication ID

B035-1143-171K

Language

English (United States)

This query returns the value '15h33m'.

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