Posted: Wed Jun 02, 2010 4:33 am Post subject: DateTime format issue
Apprentice
Joined: 22 Jan 2008 Posts: 37
Hello
Environment:
AIX 5.3, MQ6.0.2.8, WMB6.0.0.9
Message Domain: MRM
Our requirement is to:
1. validate dateTime type fields (we utilize strict date checking, and don't want to change this settings)
2. We would like to accept the following formats in a particular dateTime field:
a) yyyy-MM-dd'T'HH:mm:ss
b) yyyy-MM-dd'T'HH:mm:ss.SSS
c) yyyy-MM-dd'T'HH:mm:ss.SSSZZZ
In other words we would like that the Broker treats ".SSS" or ".SSSZZZ" as an optional suffix - what we believe is the industry standard according to xsd:dateTime documentation.
3. We would like to have the same format on output of the flow as was received from input queue.
Is it possible to do that in Broker? According to the documentation the most appropriate format for this set of requirement is "I", but it does not satisfy point 3, and accepts more formats (i.e. yyyy-MM-dd) then embedded in point 2.
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