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.