Home Page for the TeradataForum

Archives of the TeradataForum

Message Posted: Tue, 07 Apr 2009 @ 13:12:35 GMT

  <Prev Next>   <<First <Prev Next> Last>>  

From:   Geoffrey Rommel

  The timestamps DW_START_DT_TM and DW_END_DT_TM are loaded from a ource that is in UTC time. The current_timestamp is in local time.  

This sounds like a data modeling problem. Maybe the data in the table should be converted to local time, or maybe the nodes should be set to use UTC. But it's probably too late to change the data now.

  Is there a way to write a conversion that will not have to be updated twice a year?  

Certainly. Join to a calendar table that includes a flag saying whether DST applies on this date and/or the interval to be added for this date. Note that Congress regularly changes the dates of DST (there were changes in 1918, 1942, 1966, 1974, 1975, 1986, and 2007), so you can't just use a formula.

  <Prev Next>   <<First <Prev Next> Last>>  
  Top Home Privacy Feedback  
Copyright for the TeradataForum (TDATA-L), Manta BlueSky    
Copyright 2016 - All Rights Reserved    
Last Modified: 27 Dec 2016