Teradata Functions

`char2hexint`

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

function char2hexint(varchar) returns varchar

Alias for strpos() function. Examples:

examples.sql

SELECT INDEX('abcdefg', 'c') -- value '3'

Supported Signatures

function index(varchar, varchar) returns bigint

Formats timestamp as a string using format. Supported Signatures

function to_char(timestamp(p), varchar) returns varchar

Parses string into a DATE using format. Supported Signatures

function to_date(varchar, varchar) returns date

Parses string into a TIMESTAMP using format. Supported Signatures

function to_timestamp(varchar, varchar) returns timestamp