Jan Vlčinský vlcinsky
This file contains bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
| <Documents> | |
| <Document id="1" time="5/2/2010"> | |
| </Document> | |
| <Document id="2" time="4/8/2011"> | |
| </Document> | |
| <Document id="3" time="6/9/2010"> | |
| </Document> | |
| <Document id="4" time="8/10/2010"> | |
| </Document> | |
| </Documents> |
vlcinsky
/ test.xquery
Created
July 19, 2011 06:07
This file contains bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
| for $doc in //Document | |
| let $datestr := $doc/@time | |
| let $datearr := tokenize($datestr, '/') | |
| let $year := $datearr[3] | |
| let $month := format-number(xs:int($datearr[2]), '#00') | |
| let $day := format-number(xs:int($datearr[1]), '#00') | |
| let $dateisostr := concat($year, '-', $month, '-', $day) | |
| where $dateisostr > '2010-06-01' and $dateisostr < '2011-01-01' | |
| (: | |
| let $date := xs:date($dateisostr) |
vlcinsky
/ mycode.bat
Created
July 19, 2011 06:02
This file contains bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
| cd d:\var\projects |
vlcinsky
/ returned-xml-elements.xml
Created
July 18, 2011 23:22
Resulting xml elements returned by XQuery
This file contains bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
| <Document id="3" time="6/9/2010"/> | |
| <Document id="4" time="8/10/2010"/> |
This file contains bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
| <Documents> | |
| <Document id="1" time="5/2/2010"/> | |
| <Document id="2" time="4/8/2011"/> | |
| <Document id="3" time="6/9/2010"/> | |
| <Document id="4" time="8/10/2010"/> | |
| </Documents> |
vlcinsky
/ date.xquery
Created
July 18, 2011 23:09
filtering documents based on custom date format in XQuery
This file contains bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
| for $doc in //Document | |
| let $datestr := $doc/@time | |
| let $datearr := tokenize($datestr, '/') | |
| let $year := $datearr[3] | |
| let $month := format-number(xs:int($datearr[2]), '#00') | |
| let $day := format-number(xs:int($datearr[1]), '#00') | |
| let $dateisostr := concat($year, '-', $month, '-', $day) | |
| where $dateisostr > '2010-06-01' and $dateisostr < '2011-01-01' | |
| (: | |
| let $date := xs:date($dateisostr) |
NewerOlder