Daylight Saving Time | Data Types and Literals | Teradata Vantage - Daylight Saving Time - Teradata Vantage - Analytics Database

SQL Data Types and Literals

Deployment
VantageCloud
VantageCore
Edition
VMware
Enterprise
IntelliFlex
Product
Analytics Database
Teradata Vantage
Release Number
17.20
Published
June 2022
ft:locale
en-US
ft:lastEdition
2025-11-06
dita:mapPath
uds1628112204571.ditamap
dita:ditavalPath
qkf1628213546010.ditaval
dita:id
exs1472253032394
lifecycle
latest
Product Category
Teradata Vantage™

Locales that observe Daylight Saving 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.

Vantage 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. Vantage 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
  • Teradata Vantage™ - Database Administration, B035-1093
  • Teradata Vantage™ - SQL Date and Time Functions and Expressions, B035-1211
  • Teradata Vantage™ - Database Utilities, B035-1102.