Using dateTime type in XMLSchema
cscetbonSep 28 2006 — edited Sep 28 2006Hi people,
I got xml with a field date like below :
<date>2006-09-27 17:37:48</date>
I use an XMLSchema with the dateTime type for this field. With this configuration, I can have 2006-09-27T17:37:48 string entered but not mine !!!
I tried to change the pattern restriction and it can search for a specific pattern but can't change the one accepted by dateTime.
The only solution I found is to use string type for this field but that is to say that field will be stored in varchar2 and not in date column. Is there a solution to make it stored in a date column ?
Thanks.