16.20 - DATE - Teradata Vantage NewSQL Engine

Teradata Vantageā„¢ SQL Functions, Expressions, and Predicates

prodname
Teradata Database
Teradata Vantage NewSQL Engine
vrm_release
16.20
category
Programming Reference
featnum
B035-1145-162K

Purpose

Returns the current date.

Syntax



AT LOCAL
The value returned is constructed from the session time and session time zone if the DBS Control flag TimeDateWZControl is enabled.
If TimeDateWZControl is disabled, the value returned is constructed from the time value local to the Teradata Database server and the session time zone.
AT [TIME ZONE] expression

Use the time zone displacement defined by expression.

The data type of expression should be INTERVAL HOUR(2) TO MINUTE or it must be a data type that can be implicitly converted to INTERVAL HOUR(2) TO MINUTE.

AT [TIME ZONE] time_zone_string
time_zone_string determines the time zone displacement.