SQL & PL/SQL

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!

Can you help me get the time format to match XML dateTime?

361137Jul 25 2011 — edited Jul 25 2011

XML has a dateTime format which looks like this:

2002-10-10T12:00:00-05:00

and Im using XMLElement() functions in some queries to produce an xml document however it truncates the time portions of the data stored so it's just MM/DD/YYYY.

i would use a to_char function but I'm not sure what date format in Oracle to use to match the timezone portion at the end (-05:00) and how to get it to accept that 'T' in there as a separator as defined in the XML Schema spec:

http://www.w3.org/TR/xmlschema-2/

Does anyone know?

This post has been answered by Frank Kulash on Jul 25 2011

Jump to Answer

Locked Post

New comments cannot be posted to this locked post.

Locked on Aug 22 2011

Added on Jul 25 2011

5 comments

659 views