|
|
|
Re: inserting current date from xml [message #580276 is a reply to message #580274] |
Fri, 22 March 2013 03:35 ![Go to previous message Go to previous message](/forum/theme/orafaq/images/up.png) ![Go to next message Go to next message](/forum/theme/orafaq/images/down.png) |
![](http://www.orafaq.com/forum/images/custom_avatars/171883.jpg) |
sss111ind
Messages: 636 Registered: April 2012 Location: India
|
Senior Member |
![s](/forum/theme/orafaq/images/google.png)
|
|
Hi Michel,
I did not find any solution for inserting a date column from an xml to oracle.Can you please give an example or link where I have to follow.And what should be in the node.
I tried like
<startdate>2002-05-30T09:00:00</startdate> --getting litteral string does not match
<startdate>2002-05-30 09:00:00</startdate> --date format picture ends before converting entire string
<startdate>to_date('2002-05-30 09:00:00','yyyy-mm-dd hh:mi:ss')</startdate> --getting non numeric was found where numeric was excepected.
Please help me.
Regards,
Nathan
[Updated on: Fri, 22 March 2013 03:40] Report message to a moderator
|
|
|
|
Re: inserting current date from xml [message #580291 is a reply to message #580277] |
Fri, 22 March 2013 05:04 ![Go to previous message Go to previous message](/forum/theme/orafaq/images/up.png) ![Go to next message Go to next message](/forum/theme/orafaq/images/down.png) |
![](http://www.orafaq.com/forum/images/custom_avatars/171883.jpg) |
sss111ind
Messages: 636 Registered: April 2012 Location: India
|
Senior Member |
![s](/forum/theme/orafaq/images/google.png)
|
|
Hi All Thanks,
I have converted my date data type to timestamp. So now from xml end it's coming like
<start>09-oct-2012 09:23:67 pm</start>
the value is string and now It's working fine.
Sorry above all things are working fine also because extra quote is coming at beginning and ending so it was failing that time.
Regards,
Nathan
[Updated on: Fri, 22 March 2013 05:54] Report message to a moderator
|
|
|
Re: inserting current date from xml [message #580298 is a reply to message #580291] |
Fri, 22 March 2013 08:51 ![Go to previous message Go to previous message](/forum/theme/orafaq/images/up.png) |
![](http://www.orafaq.com/forum/images/custom_avatars/102589.gif) |
Michel Cadot
Messages: 68675 Registered: March 2007 Location: Nanterre, France, http://...
|
Senior Member Account Moderator |
|
|
With any SQL or PL/SQL question, please, Post a working Test case: create table (including all constraints) and insert statements along with the result you want with these data then we will be able work with your table and data. Explain with words and sentences the rules that lead to this result.
Regards
Michel
|
|
|