Skip to Main Content
Forums

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!

Date formatting in xpath

944542Jun 19 2012 — edited Jun 20 2012
Hi,

I have a requirement to display the nearest date in the xml using xpath. So i used the following function to display the nearest date and it works,

min(/virtualMachine/diskVolume/capacityDepletionDate/xs:date(xs:dateTime(.)))

Now the prob is, I need to display the date in specific format. I need in the format of Aug 20, 2012.

But the above function gives me result as 2012-08-20+05:30. So could someone help me to format this output in the xml?

Thanks,
Anand.
Comments
Locked Post
New comments cannot be posted to this locked post.
Post Details
Locked on Jul 18 2012
Added on Jun 19 2012
#xml, #xquery
5 comments
4,444 views