All Forums Database
merguaditya 1 post Joined 02/13
13 May 2016
How to Update a timestamp field in a table in Teradata to convert from GMT o CST including daylight saving

We are having a table in teradata with a time stamp field defined as UPDATE_TS TIMESTAMP(6) and having values in GMT. We need to UPDATE those values to American Central Time(With Daylight Saving).

Because the field is not defined as "timestamp with timezone", it is tricky to update with a method that takes into consideration daylight savings time.
Sample values existing in table:
05/13/2016 10:05:32.456000

Can you please help me on this ?

dnoeth 4628 posts Joined 11/04
14 May 2016

Try if this works:

             * INTERVAL '1' HOUR)

Of course you will encounter problems with two timestamps returning the same result when DST is switched back in fall.


You must sign in to leave a comment.