Reference Guide
>
TDV Support for SQL Functions
>
Convert Functions
Convert Functions
Convert functions change the format of date and time values.
TDV supports the conversion functions listed in the table.
TDV-Supported Convert Function
Comments
CAST
CAST
FORMAT_DATE
FORMAT_DATE
PARSE_DATE
PARSE_DATE
PARSE_TIME
PARSE_TIME
PARSE_TIMESTAMP
PARSE_TIMESTAMP
TIMESTAMP
TIMESTAMP
TO_BITSTRING
TO_BITSTRING
TO_CHAR
TO_CHAR
TO_DATE
TO_DATE
TO_HEX
TO_HEX
TO_NUMBER
TO_NUMBER
TO_TIMESTAMP
TO_TIMESTAMP
TO_TIMESTAMPTZ
TO_TIMESTAMP_TZ
TRUNC
See
TRUNC (for date/time)
and
TRUNC (for numbers)