CURRENT_DATE Function Syntax | VantageCloud Lake - CURRENT_DATE/CURDATE Function Syntax - 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.

AT [TIME ZONE] expression

Use the time zone displacement defined by expression.

The data type of expression must 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.