XML, XSLT and XPATH

XML, XSLT and XPATH RSS

How to Compare Date in XPath Expression

Please support our XML, XSLT and XPATH advertiser: Intel Parallel Studio Home

•

Join Date: Nov 2009

Posts: 3

Reputation: extkml is an unknown quantity at this point

Solved Threads: 0

extkml

Offline

Newbie Poster

How to Compare Date in XPath Expression

20 Days Ago

I have orders.xml like the following

 Help with Code Tags 
 XML, XSLT and XPATH Syntax (Toggle Plain Text) 
<?xml version="1.0" encoding="UTF-8" standalone="no"?>
<orders>
<order orderDate="1/1/2009" orderNo="1">
<customer id="nnghiem" name="nguyen nghiem"/>
<item id="item-1" price="25000" quantity="0"/>
<item id="item-2" price="22000" quantity="3"/>
</order>
<order orderDate="2/2/2009" orderNo="2">
<customer id="lp" name="lampard"/>
<item id="item-1" price="25000" quantity="2"/>
<item id="item-2" price="22000" quantity="8"/>
</order>
<order orderDate="3/3/2007" orderNo="3">
<customer id="nnghiem" name="nguyen nghiem"/>
<item id="item-1" price="25000" quantity="7"/>
<item id="item-2" price="22000" quantity="6"/>
</order>
</orders>
<?xml version="1.0" encoding="UTF-8" standalone="no"?>
<orders>
<order orderDate="1/1/2009" orderNo="1">
<customer id="nnghiem" name="nguyen nghiem"/>
<item id="item-1" price="25000" quantity="0"/>
<item id="item-2" price="22000" quantity="3"/>
</order>
<order orderDate="2/2/2009" orderNo="2">
<customer id="lp" name="lampard"/>
<item id="item-1" price="25000" quantity="2"/>
<item id="item-2" price="22000" quantity="8"/>
</order>
<order orderDate="3/3/2007" orderNo="3">
<customer id="nnghiem" name="nguyen nghiem"/>
<item id="item-1" price="25000" quantity="7"/>
<item id="item-2" price="22000" quantity="6"/>
</order>
</orders>

I want to retrieve every order in '2009
I solved this problem by the following way:

Help with Code Tags

XML, XSLT and XPATH Syntax (Toggle Plain Text)

String exp = "/orders/order[substring(@orderDate,string-length(@orderDate)-3)='2009']";
//... some code lines

I wonder is there any way to compare date in this situation like this:

 Help with Code Tags 
 XML, XSLT and XPATH Syntax (Toggle Plain Text) 
String exp = "/orders/order[@orderDate<'31/12/2009' and @orderDate>'1/1/2009']";
String exp = "/orders/order[@orderDate<'31/12/2009' and @orderDate>'1/1/2009']";

// get all orders between 1/1/2009 and 31/12/2009 (in year 2009)

but this exp will not return the expected result

How to solve this problem?

Thanks for your attention!

•

Join Date: Oct 2008

Posts: 2,563

Reputation: adatapost has much to be proud of

Solved Threads: 454

adatapost

Online

Posting Maven

19 Days Ago

XPath 1.0 only supports number comparison. XPath 2.0 understands the date type. With XPath 1.0 you need to do a string comparison. There is no other way.

Failure is not fatal, but failure to change might be. - John Wooden