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 thespecified date is a TIMESTAMP, DATE, or VARCHAR

• Stable if the specified date is aTIMESTAMPTZ

Parameters

date

The date to process, one of the following data types:

• VARCHAR
• DATE
• TIMESTAMP
• TIMESTAMPTZ

Examples

> SELECT YEAR_ISO(CURRENT_DATE::DATE);
 YEAR_ISO
----------
     2016
(1 row)

See also