CODE EXAMPLE FOR SQL

extract postgres

SELECT EXTRACT(YEAR FROM TIMESTAMP '2016-12-31 13:30:15');