NEXT_DAY

​

Syntax

​

Scalar

next_day(value, weekday)

​

Arguments

​

Returns

• Type: DATE
• NULL behavior: NULL input yields NULL. Invalid weekday/date text yields NULL.

​

Properties

​

Usage notes

• Trimmed, case-insensitive first two letters identify the weekday. Matching the current weekday advances seven days.

​

Examples

​

Basic example

SELECT next_day('2015-01-14','TU') AS result;

​

The same weekday means the following week

SELECT next_day('2024-03-18', 'MON') AS next_monday;

​

Limitations

• Some STRING column representations currently raise a type error. The NULL and invalid-text rules above apply to the supported STRING representation.
• Use ASCII weekday names. Non-ASCII names can fail and are outside the supported inputs.