8.26. Teradata Functions

(string) → varchar

Returns the hexadecimal representation of the UTF-16BE encoding of the string.

index(string, substring) → bigint

Alias for strpos() function.

substring(string, start) → varchar

substring(string, start, length) → varchar

Alias for 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:

Warning

Case insensitivity is not currently supported. All specifiers must be lowercase.

Formats timestamp as a string using .

to_timestamp(string, format) → timestamp

Parses string into a TIMESTAMP using format.

to_date(string, format) → date

Parses string into a DATE using format.