CURRENT_DATE Function Syntax | Teradata Vantage - CURRENT_DATE/CURDATE Function Syntax - Advanced SQL Engine - Teradata Database

SQL Functions, Expressions, and Predicates

Product
Advanced SQL Engine
Teradata Database
Release Number
17.10
Published
July 2021
Language
English (United States)
Last Update
2021-07-28
dita:mapPath
SQL_Functions__Expressions__and_Predicates.Upload_071421/djk1612415574830.ditamap
dita:ditavalPath
SQL_Functions__Expressions__and_Predicates.Upload_071421/wrg1590696035526.ditaval
dita:id
B035-1145
lifecycle
previous
Product Category
Teradata Vantageā„¢
{ CURRENT_DATE | CURDATE } [()]
  [ AT { LOCAL | [ TIME ZONE ] { expression | time_zone_string } } ]

Syntax Elements

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 Vantage 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.