Skip to Main Content

Integration

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 compare two string variables containing "DD/MM/YYYY HH24:MI:SS" data

652429May 12 2010 — edited Feb 27 2020
Hi,

A process that I am working on receives two string fields holding date/time data in the format "DD/MM/YYYY HH24:MI:SS"

e.g. "12/03/2010 16:00:00" & "29/03/2010 18:10:57"

I need to compare these two variables in order to determine which contains the greater (most recent) date.

I am not sure whether I should be using format-dateTime() xpath function on both strings, and then comparing the result of these two conversions. I think not.

Any assistance/pointers is greatly appreciated.

Regards - Anit
Comments
Locked Post
New comments cannot be posted to this locked post.
Post Details
Locked on Jun 10 2010
Added on May 12 2010
3 comments
1,514 views