IBM PureData System for Analytics, Version 7.1

The month() function

The month() function determines the month in the specified date.

You can also determine the month value by using the IBM® Netezza® date_part() function.

Description

The month() function has the following syntax:

int1 = month(date input);

The input value specifies the date.

Returns an integer representation of the month in the specified input. For example:

select month('1996-2-29');
 MONTH
-------
     2
(1 row)