IBM PureData System for Analytics, Version 7.1

The day() function

The day() function returns the numeric value of the day of the month in a specified date.

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

Description

The day() function has the following syntax:

int1 = day(date input);

The input value specifies the date.

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

select day('1996-2-29');
 DAY
-----
  29
(1 row)