Was this helpful?
SQL Functions
The following new functions are added:
DECODE
SRAND
RAND
REPEAT (REPLICATE)
INITCAP
SUBSTR
DATE_FORMAT
TIME_FORMAT
DAYOFWEEK
DAYOFMONTH
DAYOFYEAR
DOY
LAST_DAY
UNIX_TIMESTAMP
FROM_UNIXTIME
MILLISECOND
MONTHS_BETWEEN
New keywords on EXTRACT function: EPOCH, DAYOFWEEK, DAYOFYEAR, DOY, MILLISECONDS, WEEK, QUARTER, ISO_WEEK
For more information, see the SQL Reference Guide.
Last modified date: 08/29/2024