Archives of the TeradataForum
Message Posted: Tue, 07 Apr 2009 @ 13:12:35 GMT
| Subj: || || Re: CURRENT_TIMESTAMP not UTC |
| 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
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