XML dateTime formatter

VCInDSX · Post by **VCInDSX** » Wed May 23, 2007 5:17 pm

Hi Group,
In my XML output stage i need to emit date-time values for certain fields from a database column.
When i let XML Output stage to produce the datetime values, it generates datetime values like "2007-05-22 14:32:59.140". When i run this against my schema, which has these elements defined to be of type xs:dateTime, i get the following error
Datatype error: Type:InvalidDatatypeValueException, Message:Value '2007-05-22 14:32:59.140' is not in enumeration.
Looking up at http://www.w3.org/TR/xmlschema-2/#dateTime it appears that i should be emitting this as '2007-05-22T14:32:59Z'
Is there any direct routine in datastage to accomplish this or should i write my own? Or am i totally off course?

Your input/suggestions are much appreciated.
Thanks,

chulett · Post by **chulett** » Wed May 23, 2007 6:06 pm

You need to roll your own. I haven't had to worry about TZ yet, so just putting a 'T' where the space was worked for my processes.

VCInDSX · Post by **VCInDSX** » Thu May 24, 2007 9:03 am

Hi Craig,
Thanks a lot for the quick response. That was very helpful. I tried the "T" without the timezone information and it worked great.

Thanks,