XMLTABLE and date values
siromegaMay 21 2013 — edited May 21 2013I am having problems with the XMLTable function. I cant get it to see the entire date/time value in a date field.
This wont work
select x1.*
from XMLTABLE('/DOCUMENT' passing xmltype('<DOCUMENT><STR>abc def ghi</STR><NUM>1234</NUM><DT>2013-02-17T04:24:02</DT></DOCUMENT>')
columns STR varchar2(25), NUM number, DT date) x1;
However if I change the DT tag to just the date only "2013-02-17" it works. Why wont Oracle see the entire date/time format even if its ISO 8601 compliant?
Oracle DB: 11.2.0.3.0
Edited by: siromega on May 21, 2013 1:41 PM