These functions provide compatibility with Teradata SQL.
String functions
char2hexint
Returns the hexadecimal representation of the UTF-16BE encoding of the string.
index
Alias for strpos() function.
Date functions
The functions in this section use a format string that is compatible with
the Teradata datetime functions. The following table, based on the
Teradata reference manual, describes the supported format specifiers:
Case insensitivity is not currently supported. All specifiers must be lowercase.
to_char
Formats timestamp as a string using format.
to_timestamp
Parses string into a TIMESTAMP using format.
to_date
Parses string into a DATE using format.