NEXT_WEEK scalar function

The NEXT_WEEK function returns the first day of the next week after the specified date. Sunday is considered the first day of that new week.

Read syntax diagramSkip visual syntax diagramNEXT_WEEK(datetime-expression )

The schema is SYSIBM.

datetime-expression
An expression that specifies a date after which the first day of the next week is to be returned. The expression must return a value that is a DATE, a TIMESTAMP, a CHAR, or a VARCHAR data type. In a Unicode database, the expression can also be a GRAPHIC or VARGRAPHIC data type. CHAR, VARCHAR, GRAPHIC, and VARGRAPHIC are supported using implicit casting. If datetime-expression is a CHAR, VARCHAR, GRAPHIC, or VARGRAPHIC data type, it must be a valid string accepted by the TIMESTAMP scalar function.

The result of the function is DATE. If the argument can be null, the result can be null. If the argument is null, the result is the null value.

Example

The following example returns the date value of the first day of the next week after the date specified by the input:
values next_week('2007-02-18')
      Result: 2007-02-25