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.