IBM PureData System for Analytics, Version 7.1

The next_quarter() function

The next_quarter() function determines the first day of the next quarter after the date specified by the input.

Description

The next_quarter() function has the following syntax:

date = next_quarter(date input);

The input value specifies a date.

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

select next_quarter('1996-2-29');
 NEXT_QUARTER
--------------
 1996-04-01
(1 row)