Reference Guide
>
TDV Support for SQL Functions
>
Date Functions
>
EXTRACTYEAR
EXTRACTYEAR
This function returns the year part of the input timestamp value. Also see
EXTRACT
.
Syntax
SELECT EXTRACT(YEAR FROM TIMESTAMP timestamp_expr);