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 |
|
| CONVERT_FROM | CONVERT_FROM |
| CONVERT_TO | CONVERT_TO |
|
FORMAT_DATE |
|
|
PARSE_DATE |
|
|
PARSE_TIME |
|
|
PARSE_TIMESTAMP |
|
|
TIMESTAMP |
|
|
TO_BITSTRING |
|
|
TO_CHAR |
|
| TO_NCHAR | TO_NCHAR |
|
TO_DATE |
|
|
TO_HEX |
|
|
TO_NUMBER |
|
|
TO_TIMESTAMP |
|
|
TO_TIMESTAMPTZ |
|
|
TRUNC |
Subtopics