Teradata functions¶

These functions provide compatibility with Teradata SQL.

String functions¶

Function	Description	Return Type
`char2hexint(string)`	Returns the hexadecimal representation of the UTF-16BE encoding of the string.	`varchar`

Function	Description	Return Type
`index(string, substring)`	Alias for the `strpos()` function.	`bigint`

Note: Alias for strpos() function.

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	Description	Return Type
`to_char(timestamp, format)`	Formats timestamp as a string using format.	`varchar`

Function	Description	Return Type
`to_timestamp(string, format)`	Parses string into a TIMESTAMP using format.	`timestamp`

Function	Description	Return Type
`to_date(string, format)`	Parses string into a DATE using format.	`date`