📣

TiDB Cloud Premium is now in public preview. Unlimited growth, instant elasticity, advanced security for enterprise workloads. Try it out →

NEXT_DAY

Returns the date of the upcoming specified day of the week after the given date or timestamp.

Syntax

NEXT_DAY(<date_expression>, <target_day>)

Parameter	Description
`<date_expression>`	A `DATE` or `TIMESTAMP` value to calculate the next occurrence of the specified day.
`<target_day>`	The target day of the week to find the next occurrence of. Accepted values include `monday`, `tuesday`, `wednesday`, `thursday`, `friday`, `saturday`, and `sunday`.

Date.

To find the next Monday after a specific date, such as 2024-11-13:

SELECT NEXT_DAY(to_date('2024-11-13'), monday) AS next_monday;

┌─────────────┐
│ next_monday │
├─────────────┤
│ 2024-11-18  │
└─────────────┘