16.10 - Daylight Savings Time - Teradata Database

Teradata Database SQL Data Types and Literals

prodname
Teradata Database
vrm_release
16.10
created_date
June 2017
category
Programming Reference
featnum
B035-1143-161K

Locales that observe Daylight Savings Time (DST) set their clocks ahead one hour for a portion of the year for DST, then return their clocks to standard time by setting the clocks back.

Teradata Database can automatically account for DST time switching through the use of time zone strings. Time zone strings allow the definition of named time zones for locales based on their time offset from UTC. For locales that observe DST, time zone strings can include rules that define when DST starts and ends. Teradata Database uses this information to determine appropriate handling of time and date information, and to automatically adjust time zone offsets as appropriate for locales that observe DST.

For more information on... See...
Time zone strings Database Administration.

SQL Functions, Operators, Expressions, and Predicates.

the Teradata Locale Definition Utility chapter in Utilities.