MQSeries.net :: View topic - Anyone converted 'long' to 'Timestamp' in WMB 6.1?

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 » Anyone converted 'long' to 'Timestamp' in WMB 6.1?

Anyone converted 'long' to 'Timestamp' in WMB 6.1?

« View previous topic :: View next topic »

Author

Message

isaw

Posted: Wed Oct 21, 2009 6:22 am Post subject: Anyone converted 'long' to 'Timestamp' in WMB 6.1?

Apprentice

Joined: 09 May 2007
Posts: 45

Hey guys,

Been searching about and haven't found an example of what I'm looking for.

I've got an inbound XML message where multiple fields will contain a timestamp in Milliseconds, so effectively it will look like :

Code:

...
<sentTimestamp>1256037892418</sentTimestamp>
...

It's in this format because the majority of the (external) systems we'll be dealing with in this situation use timestamps in the millisecond values - from the epoch, no doubt.

I'm currently on WMB 6.1 fp5. Scanned thrugh the help pages and so far I've only come across 'TimeMilliSeconds' as a physical type to represent a dateTime element.

HERE and HERE.

However, it doesn't seem to apply to XML mset type - only the CWF. Unless I'm reading it wrong...?

Does anyone have a good way of taking a raw 'long' millisecond value and converting it into a TIMESTAMP value?

Suppose I could create a Java node to handle it but... a bit of overkill, I think.

smdavies99

Posted: Wed Oct 21, 2009 7:12 am Post subject:

Jedi Council

Joined: 10 Feb 2003
Posts: 6076
Location: Somewhere over the Rainbow this side of Never-never land.

Once a message is inside Broker AND has been parsed succesfully then in your case, the Parser Type is irrelevant. The input XML message is in a parsed tree structure of elements, attributes(if present) & values.

Why not try converting the milliseconds to a timestamp? There was a post recently that was using the millisecond values that were an hour out of sync.
_________________
WMQ User since 1999
MQSI/WBI/WMB/'Thingy' User since 2002
Linux user since 1995

Every time you reinvent the wheel the more square it gets (anon). If in doubt think and investigate before you ask silly questions.

Display posts from previous:

Page 1 of 1

MQSeries.net Forum Index » WebSphere Message Broker (ACE) Support » Anyone converted 'long' to 'Timestamp' in WMB 6.1?

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