If the DBS Control flag TimeDateWZControl is enabled, the following statements request the current time based on the current session time and time zone.
SELECT CURRENT_TIME; SELECT CURRENT_TIME AT LOCAL;
The DBS Control utility is not available for VantageCloud Lake customers. Contact Teradata Support if you want to change any DBS Control flag setting.
The result is similar to:
Current Time(0) --------------- 15:53:34+00:00
When TimeDateWZControl flag is enabled and the session time zone is defined with a time zone string that follows different Daylight Saving Time and standard time zone displacements, then CURRENT_TIME AT LOCAL gives TIME value corresponding to Standard time zone rather than the Daylight Saving Time time zone.
During the Daylight Saving Time period, CURRENT_TIME AT LOCAL follows Standard time zone, whereas CURRENT_TIME follows the Daylight Saving Time zone. During Standard time zone period, both CURRENT_TIME and CURRENT_TIME AT LOCAL follow the standard time zone.