| |
|
RSS Feed - WebSphere MQ Support
|
RSS Feed - Message Broker Support
|
  |
|
| time stamp conversion JMS to MB |
« View previous topic :: View next topic » |
| Author |
Message
|
| satyadash76 |
 Posted: Wed Feb 21, 2007 1:24 am Post subject: time stamp conversion JMS to MB |
 |
|
Newbie
Joined: 28 Apr 2006
Posts: 5
|
Hi,
I am getting 1.171601880169E12 as value of timestamp property in JMS header as which is converted into
1.171601880169E+12 by JMSMQTransport Node.
I want convert 1.171601880169E+12 value into timestamp value supported by MB.
please suggest if any body have any idea on this.
thanks in advance. |
|
| Back to top |
|
 |
| jefflowrey |
| Posted: Wed Feb 21, 2007 3:24 am Post subject: |
|
|
Grand Poobah
Joined: 16 Oct 2002
Posts: 19981
|
Did you try using CAST? Do you want to do this in ESQL, or in Java?
_________________
I am *not* the model of the modern major general. |
|
| Back to top |
|
|
| AkankshA |
| Posted: Wed Feb 21, 2007 3:30 am Post subject: |
|
|
Grand Master
Joined: 12 Jan 2006
Posts: 1494
Location: Singapore
|
the timestamp of jms header is long value (number of milliseconds since the standard base time = January 1, 1970, 00:00:00 GMT)
convert the miliseconds to seconds
Add the seconds to January 1, 1970, 00:00:00 using interval
_________________
Cheers |
|
| Back to top |
|
|
| fjb_saper |
| Posted: Wed Feb 21, 2007 3:56 am Post subject: |
|
|
Grand High Poobah
Joined: 18 Nov 2003
Posts: 20756
Location: LI,NY
|
Or use java to convert the long back into a date/Calendar object. Then use a simple date formater and you may get a date in text format. If you have a broker in v6 it will handle that...
Enjoy 
_________________
MQ & Broker admin |
|
| 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
|
|
|
|
