1. New Features in Ingres 10S : DBMS Server Enhancements : SQL Functions
 
Share this page                  
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.