Help Center/ Data Lake Insight/ SQL Syntax Reference (To Be Offline)/ Spark SQL Syntax Reference (Unavailable Soon)/ Built-in Functions/ Date Functions/ next_day
Updated on 2023-10-25 GMT+08:00
View PDF

next_day

This function is used to return the date closest to day_of_week after start_date.

Syntax

next_day(string start_date, string day_of_week)

Parameters

Table 1 Parameters

Parameter

Mandatory

Type

Description

start_date

Yes

DATE

or

STRING

Date that needs to be processed

If the value is of the STRING type, the value must contain at least yyyy-mm-dd and cannot contain redundant strings.

The following formats are supported:
  • yyyy-mm-dd
  • yyyy-mm-dd hh:mi:ss
  • yyyy-mm-dd hh:mi:ss.ff3

day_of_week

Yes

STRING

One day of a week, either the first two or three letters of the word, or the full name of the word for that day. For example, TU indicates Tuesday.

Return Values

The return value is of the DATE type, in the yyyy-mm-dd format.

  • If the value of start_date is not of the DATE or STRING type, the error message "data type mismatch" is displayed.
  • If the value of start_date is of the DATE or STRING type but is not in one of the supported formats, NULL is returned.
  • If the value of start_date is NULL, NULL is returned.
  • If the value of day_of_week is NULL, NULL is returned.

Example Code

The value 2023-08-22 is returned.

select next_day('2023-08-16','TU');

The value 2023-08-22 is returned.

select next_day('2023-08-16 10:54:00','TU');

The value 2023-08-23 is returned.

select next_day('2023-08-16 10:54:00','WE');

The value NULL is returned.

select next_day('20230816','TU');

The value NULL is returned.

select next_day('20230816 20:00:00',null);
Parent topic: Date Functions