DevOps, CI/CD and Automation

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!

How to extract date part from dateTime datatype of XML

890740Apr 19 2012 — edited Apr 19 2012

Hi all,

I have a problem with extracting the date part from the dateTime datatype. I am getting my output *2012-09-28T21:49:45* in this format. I need to extract the date part that is

*2012-09-28* excluding the time. Kindly help me out in doing this. I am new to xml world. Sorry if this question seems to be too silly but I am totally help less.

Thanks

This post has been answered by odie_63 on Apr 19 2012

Jump to Answer

Locked Post

New comments cannot be posted to this locked post.

Locked on May 17 2012

Added on Apr 19 2012

#xml, #xquery

7 comments

29,288 views