MQSeries.net :: View topic - POSIX EPOCH Conversion to readable format

MQSeries.net

Tech Exchange

Education

Certifications

Library

Info Center

SupportPacs

FAQÂ Â

Usergroups

RSS Feed - WebSphere MQ Support

RSS Feed - Message Broker Support

MQSeries.net Forum Index » WebSphere Message Broker (ACE) Support » POSIX EPOCH Conversion to readable format

POSIX EPOCH Conversion to readable format

« View previous topic :: View next topic »

Author

Message

EKhalil

Posted: Thu May 14, 2009 9:39 am Post subject: POSIX EPOCH Conversion to readable format

Voyager

Joined: 29 Apr 2003
Posts: 99
Location: Boston, MA

Hi All,

I've looked through old posts about it and got as far as this:

SET CSTdate = DATE '1970-01-01' + CAST(InputRoot.MRM.cstdatestamp /3600 / 24 AS INTERVAL DAY);

This got me the date of 2009-05-01, which is correct for the epoch = 1241172000 - Great !!!

How do I extract the hour out of epoch ? I would like to be able to pin point to the hour not only date...like May 1, 2009 6 AM
If you have any ideas, please point me in the right direction.

Thanks

mqjeff

Posted: Thu May 14, 2009 10:13 am Post subject:

Grand Master

Joined: 25 Jun 2008
Posts: 17447

What happens if you use a TIMESTAMP instead of a DATE variable?

EKhalil

Posted: Thu May 14, 2009 11:29 am Post subject:

Voyager

Joined: 29 Apr 2003
Posts: 99
Location: Boston, MA

Cool Beans !!!
Thanks

2009-05-01 10:00:00.000 obtained by:

SET HrTmStmpSec = TIMESTAMP '1970-01-01 00:00:00' + CAST(InputRoot.MRM.cstdatestamp AS INTERVAL SECOND);

Display posts from previous:

Page 1 of 1

MQSeries.net Forum Index » WebSphere Message Broker (ACE) Support » POSIX EPOCH Conversion to readable format

Jump to:

You cannot post new topics in this forum
You cannot reply to topics in this forum
You cannot edit your posts in this forum
You cannot delete your posts in this forum
You cannot vote in polls in this forum

Protected by Anti-Spam ACP