td_sunday Syntax - Analytics Database - Teradata Vantage

[TD_SYSFNLIB.] td_sunday (
  expression_1 [, { calendar_name | NULL } [, expression_2 ] ]
)

ANSI Compliance

This statement is a Teradata extension to the ANSI SQL:2011 standard.

Syntax Elements

TD_SYSFNLIB.

Name of the database where the function is located.

expression_1

An expression that results in a DATE, TIMESTAMP, or TIMESTAMP WITH TIME ZONE value.

If expression_1 is DATE, expression_2 cannot be specified.

calendar_name

A calendar name. The possible values are Teradata, ISO, and COMPATIBLE.

This argument must be a character literal and cannot be a table column or expression. If you do not name a calendar, Teradata uses the calendar for the session.

NULL

The business calendar for the session.

expression_2

A value of TIME, TIME WITH TIME ZONE, or NULL. If NULL is specified, TIME is assumed to be 00:00:00+00:00.