Teradata Functions

    char2hexint(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

    Alias for function.

    substring(string, start, length) → varchar

    Alias for substr() 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.

    to_char(timestamp, format) → varchar

    Formats timestamp as a string using .

    to_timestamp(string, format) → timestamp

    Parses string into a TIMESTAMP using format.

    Parses string into a using format.