Product Documentation

Appearance

All platforms

YEAR ​

Return the 4-digit year number from a date or timestamp expression:

YEAR(expression)

For example:

premdb=# select year(timestamp '11-30-2017 15:30:10.123456') from sys.const;
 year 
------
 2017
(1 row)

See also MONTH and DAY.