16.20 - Usage Notes - 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

TIME returns the current time when the request started. If TIME is invoked more than once during the request, the same time is returned. The time returned does not change during the duration of the request.

If you specify TIME without the AT clause or TIME AT LOCAL, then the value returned depends on the setting of the DBS Control flag TimeDateWZControl as follows:

  • If the TimeDateWZControl flag is enabled, TIME returns a time constructed from the session time and session time zone.
  • If the TimeDateWZControl flag is disabled, TIME returns a time constructed from the time value local to the Teradata Database server and the session time zone.

TIME data is stored internally in UTC, which can affect how TIME result values sort.

TIME returns a value that is adjusted to account for the start and end of daylight saving time (DST) only in the following cases:

  • TIME is specified with AT [TIME ZONE] time_zone_string, where time_zone_string follows different DST and standard time zone displacements.
  • TIME is specified with AT LOCAL or without an AT clause and the session time zone was defined with a time zone string that follows different DST and standard time zone displacements.

TIME cannot appear as the first argument in a user-defined method invocation.