F. Features Introduced in Ingres 9.1 (Ingres 2006 Release 2) : New Features in the DBMS Server : Date Functions
 
Share this page                  
Date Functions
The following date functions extract the specified portion of a date or timestamp: year(), quarter(), month(), week(), week_iso(), day(), hour(), minute(), second(), and microsecond(). For example, year('2006-12-15') returns 2006.
For more information, see the SQL Reference Guide.