IBM PureData System for Analytics, Version 7.1

The next_week() function

The next_week() function determines the first day of the next week after the specified date. Sunday is considered the first day of that new week.

Description

The next_week() function has the following syntax:

date = next_week(date input);

The input value specifies a date.

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

select next_week('2009-06-28');
 NEXT_WEEK
------------
 2009-07-05
(1 row)