EXTRACTYEAR

This function returns the year part of the input timestamp value. Also see EXTRACT.

Syntax

SELECT EXTRACT(YEAR FROM TIMESTAMP timestamp_expr);