XPath problem with dateTime strings comparison

[Viktor Jevdokimov]

Hello,

I've got an XML file saved from DataSet. One table has datetime column
(datatype - xs:dateTime). XML file fragment for example:

<Root>
<Element>2004-03-15T00:00:00.0000000+01:00</Element>
<Element>2004-03-16T00:00:00.0000000+01:00</Element>
<Element>2004-03-17T00:00:00.0000000+01:00</Element>
<Element>2004-03-18T00:00:00.0000000+01:00</Element>
</Root>

I'm trying to get MyXmlNodeList using
MyXmlDataDocument.DocumentElement.SelectNodes(MyXP athString) method, where
MyXPathString, for example, should look like:
"/Root/Element[DateFrom >= '2004-03-16T00:00:00.0000000+01:00']"

Problem: None of nodes are selected/returned if I use ">=" or "<="
comparison operators, but I could get a result using "=" operator.

Question: How to compare datetime strings?
Thank you,
Viktor

[Magnus]

See the following article:
http://www.biglist.com/lists/xsl-lis.../msg00492.html

"Viktor Jevdokimov" <vj*********@hotmail.com> skrev i meddelandet
news:uL**************@TK2MSFTNGP09.phx.gbl...

Hello,

I've got an XML file saved from DataSet. One table has datetime column
(datatype - xs:dateTime). XML file fragment for example:

<Root>
<Element>2004-03-15T00:00:00.0000000+01:00</Element>
<Element>2004-03-16T00:00:00.0000000+01:00</Element>
<Element>2004-03-17T00:00:00.0000000+01:00</Element>
<Element>2004-03-18T00:00:00.0000000+01:00</Element>
</Root>

I'm trying to get MyXmlNodeList using
MyXmlDataDocument.DocumentElement.SelectNodes(MyXP athString) method, where
MyXPathString, for example, should look like:
"/Root/Element[DateFrom >= '2004-03-16T00:00:00.0000000+01:00']"

Problem: None of nodes are selected/returned if I use ">=" or "<="
comparison operators, but I could get a result using "=" operator.

Question: How to compare datetime strings?
Thank you,
Viktor

[Yan Leshinsky]

And use XmlDocument instead of XmlDataDocument
Yan

"Magnus" <Ma********@discussions.microsoft.com> wrote in message
news:OX**************@TK2MSFTNGP11.phx.gbl...

See the following article:
http://www.biglist.com/lists/xsl-lis.../msg00492.html

"Viktor Jevdokimov" <vj*********@hotmail.com> skrev i meddelandet
news:uL**************@TK2MSFTNGP09.phx.gbl...

Hello,

I've got an XML file saved from DataSet. One table has datetime column
(datatype - xs:dateTime). XML file fragment for example:

<Root>
<Element>2004-03-15T00:00:00.0000000+01:00</Element>
<Element>2004-03-16T00:00:00.0000000+01:00</Element>
<Element>2004-03-17T00:00:00.0000000+01:00</Element>
<Element>2004-03-18T00:00:00.0000000+01:00</Element>
</Root>

I'm trying to get MyXmlNodeList using
MyXmlDataDocument.DocumentElement.SelectNodes(MyXP athString) method,
where
MyXPathString, for example, should look like:
"/Root/Element[DateFrom >= '2004-03-16T00:00:00.0000000+01:00']"

Problem: None of nodes are selected/returned if I use ">=" or "<="
comparison operators, but I could get a result using "=" operator.

Question: How to compare datetime strings?
Thank you,
Viktor

[Viktor Jevdokimov]

As I thought. Thanks.

"Magnus" <Ma********@discussions.microsoft.com> wrote in message
news:OX**************@TK2MSFTNGP11.phx.gbl...

See the following article:
http://www.biglist.com/lists/xsl-lis.../msg00492.html

"Viktor Jevdokimov" <vj*********@hotmail.com> skrev i meddelandet
news:uL**************@TK2MSFTNGP09.phx.gbl...

Hello,

I've got an XML file saved from DataSet. One table has datetime column
(datatype - xs:dateTime). XML file fragment for example:

<Root>
<Element>2004-03-15T00:00:00.0000000+01:00</Element>
<Element>2004-03-16T00:00:00.0000000+01:00</Element>
<Element>2004-03-17T00:00:00.0000000+01:00</Element>
<Element>2004-03-18T00:00:00.0000000+01:00</Element>
</Root>

I'm trying to get MyXmlNodeList using
MyXmlDataDocument.DocumentElement.SelectNodes(MyXP athString) method, where MyXPathString, for example, should look like:
"/Root/Element[DateFrom >= '2004-03-16T00:00:00.0000000+01:00']"

Problem: None of nodes are selected/returned if I use ">=" or "<="
comparison operators, but I could get a result using "=" operator.

Question: How to compare datetime strings?
Thank you,
Viktor

[Oleg Tkachenko [MVP]]

Yan Leshinsky wrote:

And use XmlDocument instead of XmlDataDocument

Or even XPathDocument if you only need to query data, not edit.

--
Oleg Tkachenko [XML MVP]
http://blog.tkachenko.com