IBM PureData System for Analytics, Version 7.1

The next_month() function

The next_month() function determines the first day of the next month after the specified date.

Description

The next_month() function has the following syntax:

date = next_month(date input);

The input value specifies a date.

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

select next_month('1996-2-29');
 NEXT_MONTH
------------
 1996-03-01
(1 row)