xml, DateTime conversions and DateTime fields

[Andy B]

I have a few questions about xml, DateTime conversions and DateTime fields.

1. in the example of DateTime.Now, how would you save it in the format
yyyy-mm-ddThh:mm:ssZ for xml storage?
2. If I have an xml attribute date="2008-09-25T13:15:00Z", How would I load
that into a DateTime variable?
3. Where can I get a list of valid time zone codes for use in xml storage?

Thanks for your help and answers.
P.S. My codebehind is VB.net in vs2008 sp1.

[rrutkowski@gmail.com]

Re: xml, DateTime conversions and DateTime fields

On 25 Wrz, 12:05, "Andy B" <a_bo...@sbcglo bal.netwrote:

I have a few questions about xml, DateTime conversions and DateTime fields.
>
1. in the example of DateTime.Now, how would you save it in the format
yyyy-mm-ddThh:mm:ssZ for xml storage?
2. If I have an xml attribute date="2008-09-25T13:15:00Z", How would I load
that into a DateTime variable?

I would simply use the ToString and ToDateTime methods of the
XmlConvert class.

--
Rudy

[Martin Honnen]

Re: xml, DateTime conversions and DateTime fields

Andy B wrote:

2. If I have an xml attribute date="2008-09-25T13:15:00Z", How would I load
that into a DateTime variable?

P.S. My codebehind is VB.net in vs2008 sp1.

You could use LINQ to XML then where you can simply cast the XAttribute
to a DateTime e.g.

Dim bar As XElement = <bar dt="2008-09-25T13:15:00Z"/>
Dim dt As DateTime = CType(bar.Attri bute("dt"), DateTime)
Console.WriteLi ne(dt)

--

Martin Honnen --- MVP XML

http://JavaScript.FAQTs.com/