Ingres 11.0 | SQL Functions

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: 01/30/2023