These functions provide compatibility with Teradata SQL.

String functions

char2hexint

char2hexint(string) -> varchar
Returns the hexadecimal representation of the UTF-16BE encoding of the string.

index

index(string, substring) -> bigint
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:
SpecifierDescription
- / , . ; :Punctuation characters are ignored
ddDay of month (1-31)
hhHour of day (1-12)
hh24Hour of the day (0-23)
miMinute (0-59)
mmMonth (01-12)
ssSecond (0-59)
yyyy4-digit year
yy2-digit year
Case insensitivity is not currently supported. All specifiers must be lowercase.

to_char

to_char(timestamp, format) -> varchar
Formats timestamp as a string using format.

to_timestamp

to_timestamp(string, format) -> timestamp
Parses string into a TIMESTAMP using format.

to_date

to_date(string, format) -> date
Parses string into a DATE using format.