NEXT_DAY

Description

The NEXT_DAY function is used to return the first date that is later than the given date and matches the specified day of the week.

:::tip This function is supported since version 3.0.6. :::

Syntax

NEXT_DAY(<datetime/date>, <day_of_week>)

Parameters

Parameter	Description
`<datetime/date>`	The date which will be used to find the next day of the week.
`<day_of_week>`	A STRING expression identifying a day of the week.

<day_of_week> must be one of the following (case insensitive):

'SU', 'SUN', 'SUNDAY'
'MO', 'MON', 'MONDAY'
'TU', 'TUE', 'TUESDAY'
'WE', 'WED', 'WEDNESDAY'
'TH', 'THU', 'THURSDAY'
'FR', 'FRI', 'FRIDAY'
'SA', 'SAT', 'SATURDAY'

Return Value

A DATE value whatever the input is DATETIME or DATE.

Special cases:

If the <datetime/date> input is NULL, the function returns NULL.
If the input is NEXT_DAY("9999-12-31 12:00:00", <day_of_week>), the function will return same value as the input.

Example

select next_day("2020-01-31 02:02:02", "MONDAY"),next_day("2020-01-31", "MONDAY");

+--------------------------------------------+-----------------------------------+
| next_day("2020-01-31 02:02:02", "MONDAY")  | next_day("2020-01-31", "MONDAY")  |
+--------------------------------------------+-----------------------------------+
| 2020-02-03                                 | 2020-02-03                        |
+--------------------------------------------+-----------------------------------+

MONTHS_SUB NOW