year() function
The year() function determines the year of a specified date.
You can also determine the year value by using the Netezza Performance Server date_part() function.
Syntax
The year() function has the following
syntax:
int2 = year(date input);
The input value
specifies the date.
Returns
The function returns an integer representation of the year of the specified date.
Example
This example returns 1996:
select year('1996-2-29');
YEAR
------
1996
(1 row)