Portal | Manuals | References | Downloads | Info | Programs | JCLs | Mainframe wiki | Quick Ref
IBM Mainframe Computers Forums Index
 
Register
 
IBM Mainframe Computers Forums Index Mainframe: Search IBM Mainframe Forum: FAQ Memberlist Profile Log in to check your private messages Log in
 
TIMESTAMP convertion from UTC to EST/PST/CST

 
Post new topic   Reply to topic    IBMMAINFRAMES.com Support Forums -> DB2
View previous topic :: :: View next topic  
Author Message
mallik4u

New User


Joined: 17 Sep 2008
Posts: 75
Location: bangalore

PostPosted: Mon Jun 02, 2014 1:13 pm    Post subject: TIMESTAMP convertion from UTC to EST/PST/CST
Reply with quote

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
View user's profile Send private message

GuyC

Senior Member


Joined: 11 Aug 2009
Posts: 1281
Location: Belgium

PostPosted: Tue Jun 03, 2014 1:07 pm    Post subject:
Reply with quote

Code:
select TS_Col at timezone '-08:00' from ...

should work
Back to top
View user's profile Send private message
mallik4u

New User


Joined: 17 Sep 2008
Posts: 75
Location: bangalore

PostPosted: Tue Jun 03, 2014 8:57 pm    Post subject:
Reply with quote

Thank you very much. That helped.
Back to top
View user's profile Send private message
View previous topic :: :: View next topic  
Post new topic   Reply to topic    IBMMAINFRAMES.com Support Forums -> DB2 All times are GMT + 6 Hours
Page 1 of 1

 

Search our Forum:

Similar Topics
Topic Author Forum Replies Posted
No new posts How to get MQPUT Timestamp? Rohit Umarjikar Java & MQSeries 3 Wed Aug 08, 2018 10:33 am
No new posts row change timestamp charanmsrit DB2 3 Tue Jul 10, 2018 12:30 pm
This topic is locked: you cannot edit posts or make replies. UTC Timestamp Log Thangavel COBOL Programming 5 Mon Jan 22, 2018 9:04 pm
No new posts Converting EBCDIC to Unicode (TimeStamp) muralikrishnan_new COBOL Programming 2 Mon Jul 25, 2016 10:42 pm
No new posts Convert Timestamp Value mrdinesh DFSORT/ICETOOL 7 Thu May 05, 2016 6:01 pm

Facebook
Back to Top
 
Job Vacancies | Forum Rules | Bookmarks | Subscriptions | FAQ | Polls | Contact Us