| |
|
RSS Feed - WebSphere MQ Support
|
RSS Feed - Message Broker Support
|
  |
|
| Follow up on EPOC time (Urgent) |
« View previous topic :: View next topic » |
| Author |
Message
|
| smeunier |
 Posted: Mon Aug 23, 2004 6:24 am Post subject: Follow up on EPOC time (Urgent) |
 |
|
Partisan
Joined: 19 Aug 2002
Posts: 305
Location: Green Mountains of Vermont
|
Please see this thread for the discussion. In short, I have posted new information concerning a discrepency of 4 hrs on an evaluated time, which represent the EPOC data/time on milliseconds. I have been trying to debug this for a while no with no avail. Is it a INTERVAL problem, or a GMT problem? Please follow this thread and see my last posting.
http://www.mqseries.net/phpBB2/viewtopic.php?t=12671&highlight=epoc |
|
| Back to top |
|
 |
| kirani |
| Posted: Mon Aug 23, 2004 10:18 pm Post subject: |
|
|
Jedi Knight
Joined: 05 Sep 2001
Posts: 3779
Location: Torrance, CA, USA
|
As PGoodhart said, please open a ticket with IBM for this problem.
_________________
Kiran
IBM Cert. Solution Designer & System Administrator - WBIMB V5
IBM Cert. Solutions Expert - WMQI
IBM Cert. Specialist - WMQI, MQSeries
IBM Cert. Developer - MQSeries
|
|
| Back to top |
|
|
| shanson |
| Posted: Wed Aug 25, 2004 8:05 am Post subject: |
|
|
Partisan
Joined: 17 Oct 2003
Posts: 344
Location: IBM Hursley
|
The 4 hour discrepancy could be explained by time zone difference. The difference between GMT and EST with daylight savings time is 4 hours. That's a bit of a coincidence  . |
|
| Back to top |
|
|
| smeunier |
| Posted: Thu Aug 26, 2004 4:38 am Post subject: |
|
|
Partisan
Joined: 19 Aug 2002
Posts: 305
Location: Green Mountains of Vermont
|
I agree it is a coincedence! Here is what I finally did. I agree with previous appened to this problem, that it is a product issue with date caluculation. The trace interpets correctly, but not at the message flow level. I'm not sure if I will still be in sync when we switch back to DT in October.
| Code: |
-- Set EPOC start
SET EpocTimeStamp = TIMESTAMP '1970-01-01 00:00:00';
-- Get milliseconds from EPOC to today
SET EventInterval = ((CURRENT_TIMESTAMP - EpocTimeStamp) SECOND) * 1000;
-- Get Local Time zone differential(in milliseconds)
SET EventZone = (ABS(CAST(LOCAL_TIMEZONE AS INTEGER)* 60) * 1000);
Set current date as offset in milliseconds
SET TimeInMilliSeconds = ((CAST(EventInterval AS INTEGER)) + (CAST(EventZone as INTEGER)));
|
This could have done this more eloquently, but the LOCAL_TIMEZONE return and interval of minutes. I would have liked to get that in seconds and do one conversion to milliseconds. If anyone knows how to do that. I'd be interested. |
|
| Back to top |
|
|
|
|
|
| |
|
Page 1 of 1 |
|
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
|
|
|
|
