"Magnus" <Magnus_SWE@discussions.microsoft.com> wrote in message
news:OXXXJUfOEHA.3744@TK2MSFTNGP11.phx.gbl...
> See the following article:
> http://www.biglist.com/lists/xsl-list/archives/200203/msg00492.html
>
> "Viktor Jevdokimov" <vjevdokimov@hotmail.com> skrev i meddelandet
> news:uLy1VQdOEHA.2780@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(MyXPathString) 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
>>
>>
>
>

> 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(MyXPathString) 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" <Magnus_SWE@discussions.microsoft.com> wrote in message
news:OXXXJUfOEHA.3744@TK2MSFTNGP11.phx.gbl...
> See the following article:
> http://www.biglist.com/lists/xsl-list/archives/200203/msg00492.html
>
> "Viktor Jevdokimov" <vjevdokimov@hotmail.com> skrev i meddelandet
> news:uLy1VQdOEHA.2780@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(MyXPathString) 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 wrote:

> And use XmlDocument instead of XmlDataDocument