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
Case insensitivity is not currently supported. All specifiers must be lowercase.
