this_month() function

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

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

Syntax

The this_month() function has the following syntax:
date = this_month(date input);

The input value specifies a date.

Returns

The function returns a date that represents the first day of the specified month.

Example

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