| |
|
RSS Feed - WebSphere MQ Support
|
RSS Feed - Message Broker Support
|
  |
|
| dateTime format in MB6 |
« View previous topic :: View next topic » |
| Author |
Message
|
| saturn_cemk |
 Posted: Thu Jan 25, 2007 2:20 pm Post subject: dateTime format in MB6 |
 |
|
Novice
Joined: 10 Jul 2006
Posts: 16
|
Hello everyone,
I am having an input XML message with an element in it whose type is dateTime. A message set is being used to parse the XML message.
Now the value for this element in the XML message is 2006-11-05T08:15:30-08:00, which actually conforms to the ISO8601 standard. The Physical representation of the DateTime format in the message set was initially yyyy-MM-dd'T'HH:mm:ssZZZ. But when I tried to parse the message I was unable to do so. I was getting an error.
So I thought of changing the DateTime format in the message set to 'I', which represents the ISO8601 DateTime. Now when I parse the message I get 2007-11-05 08:15:30.000 as the output. I am not sure as to how the -08:00 gets replaced by .000.
Can anyone please suggest on this ?
Thank you |
|
| Back to top |
|
 |
| EddieA |
| Posted: Thu Jan 25, 2007 4:38 pm Post subject: |
|
|
Jedi
Joined: 28 Jun 2001
Posts: 2453
Location: Los Angeles
|
Your oringinal date/time was not correct ISO8601. The format of an ISO8601 date/time is: yyyy-MM-dd'T'HH:mm:ss.SSSZZZ. However, the value does match your pattern, and so should have parsed. What was the error you were getting.
I'm surprised that the value parsed using I, as the value, as explained above, is not ISO8601 compliant. However, the .000 is the 1/100ths of a second.
**Update** That format of the ISO8601 is taken from the Broker Info Center, and so I would assume is what the Broker requires, not the W3 documentation.
Cheers,
_________________
Eddie Atherton
IBM Certified Solution Developer - WebSphere Message Broker V6.1
IBM Certified Solution Developer - WebSphere Message Broker V7.0 |
|
| Back to top |
|
|
| saturn_cemk |
| Posted: Thu Jan 25, 2007 5:32 pm Post subject: |
|
|
Novice
Joined: 10 Jul 2006
Posts: 16
|
Hello Eddie,
I was getting a parser error in the first case. Altough I do not remember the exact error text but it was something to do with wrong DateTime format.
In the second scenario altough it parses the date with 'I' as the DateTime format but then it does not show the time zone part in the output. Why is this ?
I tried with another element value 2001-12-17T09:30:47.0Z which is also getting parsed with 'I' as the DateTime format. And the output I'm getting is 2001-12-17 09:30:47.000
I am not sure as to what format I should use. Any suggestion will be appreciated.
Thank you. |
|
| Back to top |
|
|
| nemesis |
| Posted: Fri Jan 26, 2007 10:40 am Post subject: |
|
|
Newbie
Joined: 10 Jan 2007
Posts: 4
|
| Even I am facing a similar kind of problem. The output does not show the timezone information. It vanishes ! Can anyone help ? |
|
| 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
|
|
|
|
