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