NEXT_DAY
Returns the date of the first instance of a particular day of the week that follows the specified date.
Behavior Type
- Immutable if the
specified date is a
TIMESTAMP
,DATE
, orVARCHAR
- Stable if the specified date is a
TIMESTAMPTZ
Syntax
NEXT_DAY( 'date', 'day‑string')
Parameters
date |
The date to process, one of the following data types: |
day‑string |
The day of the week to process, a CHAR or VARCHAR string or character constant. Supply the full English name such as Tuesday, or any conventional abbreviation, such as Tue or Tues. day‑string is not case sensitive and trailing spaces are ignored. |
Examples
Get the date of the first Monday that follows April 29 2016:
=> SELECT NEXT_DAY('4-29-2016'::TIMESTAMP,'Monday') "NEXT DAY" ; NEXT DAY ------------ 2016-05-02 (1 row)
Get the first Tuesday that follows today:
SELECT NEXT_DAY(CURRENT_TIMESTAMP,'tues') "NEXT DAY" ; NEXT DAY ------------ 2016-05-03 (1 row)