next_week() function

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

Syntax

The next_week() function has the following syntax:

date = next_week(date input);

The input value specifies a date.

The function returns a date value that represents the first day of the next week after the specified date.

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