next_day
function
Applies to: Databricks SQL Databricks Runtime
Returns the first date which is later than expr
and named as in dayOfWeek
.
Syntax
next_day(expr, dayOfWeek)
Arguments
expr
: A DATE expression.dayOfWeek
: A STRING expression identifying a day of the week.
Returns
A DATE.
dayOfWeek 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'
Note
In Databricks Runtime, if spark.sql.ansi.enabled is false
, the function returns NULL
instead of an error for a malformed dayOfWeek
.
Examples
> SELECT next_day('2015-01-14', 'TU');
2015-01-20
Related functions
Feedback
https://aka.ms/ContentUserFeedback.
Coming soon: Throughout 2024 we will be phasing out GitHub Issues as the feedback mechanism for content and replacing it with a new feedback system. For more information see:Submit and view feedback for