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
timestamp
as a string usingformat
.
- to_timestamp(string, format) timestamp #
Parses
string
into aTIMESTAMP
usingformat
.
- to_date(string, format) date #
Parses
string
into aDATE
usingformat
.