IBM PureData System for Analytics, Version 7.1

The this_month() function

The this_month() function determines the first day of the month in the specified date.

You can also determine the first day of the month value by using the IBM® Netezza® date_trunc() function.

Description

The this_month() function has the following syntax:

date = this_month(date input);

The input value specifies a date.

Returns a date that represents the first day of the month specified by input. For example:

select this_month('1996-2-29');
 THIS_MONTH
------------
 1996-02-01
(1 row)