[basex-talk] date field ordering

20 Sep 2012


      Dear Basex,

Could you please help us in writing xquery for ordering xml based on date field(bDate).For example I have a xml with following nodes

<Results>
  <GROUPBYVAL>
    <bDate>01-JUN-12</bDate>
  </GROUPBYVAL>
  <GROUPBYVAL>
    <bDate>10-AUG-12</bDate>
  </GROUPBYVAL>
  <GROUPBYVAL>
    <bDate>21-FEB-12</bDate>
  </GROUPBYVAL>
</Results>

query should take input as the above xml and should return output in the below format

<Results>
  <GROUPBYVAL>
  <bDate>10-AUG-12</bDate>
  </GROUPBYVAL>
  <GROUPBYVAL>
    <bDate>21-JUL-12</bDate>
  </GROUPBYVAL>
  <GROUPBYVAL>
 <bDate>01-FEB-12</bDate>
  </GROUPBYVAL>
</Results>

Thanks & Regards
Hariprasad.d