NEXT_DAY Syntax - Teradata VantageCloud Lake

Lake - Working with SQL

Deployment
VantageCloud
Edition
Lake
Product
Teradata VantageCloud Lake
Release Number
Published
February 2025
ft:locale
en-US
ft:lastEdition
2025-11-21
dita:mapPath
jbe1714339405530.ditamap
dita:ditavalPath
pny1626732985837.ditaval
dita:id
jbe1714339405530
[TD_SYSFNLIB.] NEXT_DAY ( date_timestamp_value, day_value )

Syntax Elements

TD_SYSFNLIB.
Name of the database where the function is located.
date_timestamp_value
A date or timestamp argument.
day_value

A character argument.

day_value can be any day of the week or its 3-character abbreviation.

Valid values are:
  • 'SUNDAY' or 'SUN'
  • 'MONDAY' or 'MON'
  • 'TUESDAY' or 'TUE'
  • 'WEDNESDAY' or 'WED'
  • 'THURSDAY' or 'THU'
  • 'FRIDAY' or 'FRI'
  • 'SATURDAY' or 'SAT'

The day of week is not case-sensitive. Any characters that follow a valid abbreviation are ignored.

If this syntax element is NULL, NULL is returned.