Example: Requesting the Current Timestamp

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

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

If the DBS Control flag TimeDateWZControl is enabled, the following statements request the current timestamp based on the current session time and time zone.

   SELECT CURRENT_TIMESTAMP;
   SELECT CURRENT_TIMESTAMP AT LOCAL;

The result is similar to:

               Current TimeStamp(6)
   --------------------------------
   2001-11-27 15:53:34.910000+00:00

If the session time zone was defined with a time zone string that follows different DST and standard time zone displacements, then the timestamp returned is automatically adjusted to account for the start and end of daylight saving time. Otherwise, no adjustment for daylight saving time is done.