Teradata functions#
These functions provide compatibility with Teradata SQL.
String functions#
- char2hexint(string) varchar#
- Returns the hexadecimal representation of the UTF-16BE encoding of the string. 
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 | 
| 
 | Day of month (1-31) | 
| 
 | Hour of day (1-12) | 
| 
 | Hour of the day (0-23) | 
| 
 | Minute (0-59) | 
| 
 | Month (01-12) | 
| 
 | Second (0-59) | 
| 
 | 4-digit year | 
| 
 | 2-digit year | 
Warning
Case insensitivity is not currently supported. All specifiers must be lowercase.
- to_char(timestamp, format) varchar#
- Formats - timestampas a string using- format.
- to_timestamp(string, format) timestamp#
- Parses - stringinto a- TIMESTAMPusing- format.
- to_date(string, format) date#
- Parses - stringinto a- DATEusing- format.