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!

Xquery dateTime format conversion

bhaskarNov 26 2013 — edited Dec 2 2013

Hi All,

I need an help for date and time format conversion. A working java method has to be converted to Xquery function to be integrated into fusion middleware. Not sure whether any suitable Xquery function is existing for this.

Scenario:

-------------

Basically, I have inputDate (instance of SimpleDateFormat in java) defined in "MM/dd/yyyy HH:mm:ss" and outputDate in "MMddyyyy" format. Any incoming String should be parsed into inputDate format and then converted to outputDate format.

Example : Incoming String - 12/26/2013 14:21:33  Outcoming 12262013

I know in java it is easy, but any suggestions in xquery, appreciated.

Thanks,

Bhaskar
This post has been answered by odie_63 on Nov 29 2013
Jump to Answer
Comments
Locked Post
New comments cannot be posted to this locked post.
Post Details
Locked on Dec 30 2013
Added on Nov 26 2013
#xml, #xquery
11 comments
10,129 views