XPath 1.0 - timestring comparison



I've got this comparison in XPath1.0:


number(substring(translate(translate(translate(@pub-date,'-',''),':',''),' ','') ,5,4)+substring(translate(translate(translate(@pub-date,'-',''),':',''),' ',''),2,3)+substring(translate(translate(translate(@pub-date,'-',''),':',''),' ',''),0,2)+substring(translate(translate(translate(@pub-date,'-',''),':',''),' ',''),9,6)) > number(substring(translate(translate(translate(@pub-date2,'-',''),':',''),' ','') ,5,4)+substring(translate(translate(translate(@pub-date2,'-',''),':',''),' ',''),2,3)+substring(translate(translate(translate(@pub-date2,'-',''),':',''),' ',''),0,2)+substring(translate(translate(translate(@pub-date2,'-',''),':',''),' ',''),9,6))


This compares @pub-date and @pub-date2. These Strings have this format: dd-mm-yyyy hh:mm:ss.


The problem is: is @pub-date = "30-07-2014 23:59:59" and @pub-date2 = "30-08-2014 00:00:00", @pub-date is considered bigger than @pub-date2. What's wrong with this XPath?


No comments:

Post a Comment