================== Teradata Functions ================== These functions provide compatibility with Teradata SQL. String Functions ---------------- .. function:: char2hexint(string) -> varchar Returns the hexadecimal representation of the UTF-16BE encoding of the string. .. function:: index(string, substring) -> bigint Alias for :func:`strpos` function. .. function:: substring(string, start) -> varchar Alias for :func:`substr` function. .. function:: substring(string, start, length) -> varchar Alias for :func:`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: =============== =========== Specifier Description =============== =========== ``- / , . ; :`` Punctuation characters are ignored ``dd`` Day of month (1-31) ``hh`` Hour of day (1-12) ``hh24`` Hour of the day (0-23) ``mi`` Minute (0-59) ``mm`` Month (01-12) ``ss`` Second (0-59) ``yyyy`` 4-digit year ``yy`` 2-digit year =============== =========== .. warning:: Case insensitivity is not currently supported. All specifiers must be lowercase. .. function:: to_char(timestamp, format) -> varchar Formats ``timestamp`` as a string using ``format``. .. function:: to_timestamp(string, format) -> timestamp Parses ``string`` into a ``TIMESTAMP`` using ``format``. .. function:: to_date(string, format) -> date Parses ``string`` into a ``DATE`` using ``format``.