Timestamp upation issue

Database
Enthusiast

Timestamp upation issue

Hi,

When i am trying to do an update as below, the open_ts becomes - 3/8/2009 03:01:05 instead i expect it to be - 3/8/2009 02:01:05

UPDATE mydata.mytab1 SET OPEN_TS = '2009-03-08 02:01:05' WHERE ACCT_ID = 17001565;

I think, this has soemthing to take with time zone and day light saving, but i am unable to decipher it.  Can someone help me on this ?

Thanks !

Samir

6 REPLIES
Enthusiast

Re: Timestamp upation issue

Hi All,

Can someone help me on this ?

--Samir Singh

Enthusiast

Re: Timestamp upation issue

That was a Daylight savings date, the clocks will be pushed by 1 hour at 2.00 AM to 3.00 AM. 

Enthusiast

Re: Timestamp upation issue

Thanks Kirthi, so will there be no 2:00 AM on that day ? What if i want to update the time as 2:00 on that day ?

Enthusiast

Re: Timestamp upation issue

You can do it 2 ways.

At system level

 You might need to change the setting for the DBS Control flag TimeDateWZControl.

At Session Level

SET TIME ZONE 'GMT+5:30'   ( This is India Time zone where they dont use Day light savings and the time '2009-03-08 02:01:05' is a valid time there)

run the update SQL, you should see the data as you expected.

If you want to check the allowed time zone strings please refer to below link.

http://www.info.teradata.com/HTMLPubs/DB_TTU_14_00/index.html#page/SQL_Reference/B035_1184_111A/End_...

Teradata Employee

Re: Timestamp upation issue

WARNING - Do not change TimeDateWZControl value without reviewing all the implications carefully and talking it over with Teradata support.

Enthusiast

Re: Timestamp upation issue

Thanks everyone, this was helpful.