Appearance
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)
Parent topic:Datetime Functions