14.19. 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.