Database Software

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

Database only likes one flavour of DateTime format

Simon GaddMay 28 2009 — edited Jun 29 2009

Hi Folks.

Making great progress with my XML loading thanks to support on the forum and also examining other posts.

My current issue is this. I am loading XML into an XMLTYPE column. This column resides in a table which was associated with a registred XML schema.

All of the documents I am trying to load claim to be compliant with the registered schema.

Where the header contains a "creationTimestamp" element in this format the system loads the XML with no problem

<DocumentHeader creationTimestamp="2009-02-04T14:18:58">

If, however, the timestamp looks like this..

<DocumentHeader creationTimestamp="2009-05-05T14:55:18+02:00">

or this

<DocumentHeader creationTimestamp="2009-04-22T14:52:52.61Z">

or this

<DocumentHeader creationTimestamp="2008-07-01T04:04:00Z">

I get the following error...

ORA-30992: error occurred at Xpath /IndividualAnnex/DocumentHeader[@creationTimestamp] ORA-01830: date format picture ends before converting entire input string

Assuming the XML documents DO confirm to the schema but they simply have slightly different date time formats, is there a way I could load them into my table?

Any suggestions appreciated.

Kind regards

Simon Gadd

Locked Post

New comments cannot be posted to this locked post.

Locked on Jul 27 2009

Added on May 28 2009

#performance-availability, #xml-db

8 comments

2,568 views