Teradata Functions

​

char2hexint

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

Supported Signatures

function char2hexint(varchar) returns varchar

🔗 Official Documentation

​

index

Alias for strpos() function.

Examples:

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

Supported Signatures

function index(varchar, varchar) returns bigint

🔗 Official Documentation

​

to_char

Formats timestamp as a string using format.

Supported Signatures

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

🔗 Official Documentation

​

to_date

Parses string into a DATE using format.

Supported Signatures

function to_date(varchar, varchar) returns date

🔗 Official Documentation

​

to_timestamp

Parses string into a TIMESTAMP using format.

Supported Signatures

function to_timestamp(varchar, varchar) returns timestamp

🔗 Official Documentation