XML/DB2/Timestamp problem

[stoggers]

Hi,

I have used XMLSPY's facility to reverse engineer a DB2 database into an XML schema.

However, I hit problems with DB2's timestamp columns.

The data is extracted as: 2000-08-01 12:00:00.000000

However the schema expects: 2000-08-01T12:00:00.000000

The pattern is: \p{Nd}{4}-\p{Nd}{2}-\p{Nd}{2}T\p{Nd}{2}:\p{Nd}{2}:\p{Nd}{2}.\p{Nd}{6}

The problem seems to be that only the chracter 'T' is allowed as a separator between the date component and th etime component.

How can I construct a valid schema?

Thanks,

Stoggers.

 

[chiph]

The one with the "T" is the valid one -- XML uses ISO-8601 date/time format.

I would look at the tool you're using the extract the data, and see if there's a way to tell it to export dates in the correct format.

Chip H.


____________________________________________________________________
If you want to get the best response to a question, please read FAQ222-2244 first