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.