YEAR_ISO
Returns an integer that represents the year portion of the specified date. The return value is based on the ISO 8061 standard.
The first week of the ISO year is the week that contains January 4.
Syntax
YEAR_ISO ( date )
Behavior Type
- Immutable if the
specified date is a
TIMESTAMP,DATE, orVARCHAR - Stable if the specified date is a
TIMESTAMPTZ
Parameters
|
date |
The date to process, one of the following data types: |
Examples
> SELECT YEAR_ISO(CURRENT_DATE::DATE);
YEAR_ISO
----------
2016
(1 row)