View previous topic :: View next topic
|
Author |
Message |
mallik4u
New User
Joined: 17 Sep 2008 Posts: 75 Location: bangalore
|
|
|
|
Hi,
In DB2V10 TIMESTAMP WITH TIMEZONE has been introduced. I would like to know is there any way to convert TIMESTAMP stored in table (WITH TIMEZONE) to different timezone. For example: If the local timezone is CST then DB2 will produce timestamp in CST and adds '-05:00' as time difference between CST and UTC. Now how we can derive PST time from this time stamp?
I could not find any documentation on time conversion in internet.
Thanks,
Mallik |
|
Back to top |
|
|
GuyC
Senior Member
Joined: 11 Aug 2009 Posts: 1281 Location: Belgium
|
|
|
|
Code: |
select TS_Col at timezone '-08:00' from ... |
should work |
|
Back to top |
|
|
mallik4u
New User
Joined: 17 Sep 2008 Posts: 75 Location: bangalore
|
|
|
|
Thank you very much. That helped. |
|
Back to top |
|
|
|