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.
index(string, substring) -> bigint
Alias for strpos
function.
substring(string, start) -> varchar
Alias for substr
function.
substring(string, start, length) -> varchar
Alias for substr
function.
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 |
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.
to_char(timestamp, format) -> varchar
Formats timestamp
as a string using format
.
to_timestamp(string, format) -> timestamp
Parses string
into a TIMESTAMP
using format
.
to_date(string, format) -> date
Parses string
into a DATE
using format
.