MQSeries.net :: View topic - problem in date & time parsing..separately

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 » problem in date & time parsing..separately

problem in date & time parsing..separately

« View previous topic :: View next topic »

Author

Message

sirsi

Posted: Wed Apr 12, 2006 5:50 am Post subject:

Disciple

Joined: 11 Mar 2005
Posts: 177

which version of MB you are using?

shanson

Posted: Wed Apr 12, 2006 6:05 am Post subject:

Partisan

Joined: 17 Oct 2003
Posts: 344
Location: IBM Hursley

You should certainly be setting option 2 - derive datetime format from logical type, as your formats are different for each type of data (date, time). But all this does is derive a default format - you need to examine each date/time element to see if this format is correct.

Do the following:
- Set the message set property as above
- Look at the MRM XML format properties for the xs:date element. I would expect it to have a Format property of 'yyyy-MM-dd', which will parse the data correctly.
- Look at the MRM XML format properties for the xs:time element. I would expect it to have a Format property of 'HH:mm:ssZZZ', which will not parse the data correctly. You need to change it to 'HH:mm:ss.SSSSSS'.

Hopefully this should work. The help topic that defines the format patterns may be found by searching on ad09291_ in the help system.

Display posts from previous:

Page 1 of 1

MQSeries.net Forum Index » WebSphere Message Broker (ACE) Support » problem in date & time parsing..separately

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