xpath and queries using date functions

Question

I have an xml file containing a lists of nodes with a "date" attribute, storing a date:

<root>
    <entry date="2011-12-04" />
    <entry date="2011-11-29" />
</root>

Is it possible using a xPath query to retrive all the nodes that have the month of the "date" attribute set to november?
I read on the web (for example here) that this kind of functions exists in the xPath language, but I am not able to figure how to use them.
I should using this in a java application.

Eli Acherkan · Accepted Answer · 2011-12-05 16:46:25Z

3

The following XPath works for me:

//entry[month-from-date(@date)=11]

(Replace entry with * to select all the nodes with a November date attribute, regardless of the node name.)

answered Dec 5, 2011 at 16:46

Eli Acherkan

6,4112 gold badges29 silver badges34 bronze badges

Sign up to request clarification or add additional context in comments.

1 Comment

Vincent Biragnet Over a year ago

It may be important to add that this function is only available with XPath 2.0.

Reverend Gonzo · Accepted Answer · 2011-12-05 16:36:31Z

2

I haven't used the date functions, but you could use substring to extract the month and test that value, for example:

'//entry[substring(@date,6,2)="11"]'

returns just

<entry date="2011-11-29" />

answered Dec 5, 2011 at 16:36

Reverend Gonzo

41.1k6 gold badges61 silver badges78 bronze badges

1 Comment

Davide Gualano Over a year ago

I went the substring way,because I cannot use XPath 2 functions. Thanks.

Collectives™ on Stack Overflow

xpath and queries using date functions

2 Answers 2

1 Comment

1 Comment

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

1 Comment

1 Comment

Your Answer

Sign up or log in

Post as a guest

Related