Skip to main content
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.