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