xml, DateTime conversions and DateTime fields

  • Thread starter Thread starter Andy B
  • Start date Start date
A

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.
 
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?
Click to expand...

I would simply use the ToString and ToDateTime methods of the
XmlConvert class.
 
Andy said:
2. If I have an xml attribute date="2008-09-25T13:15:00Z", How would I load
that into a DateTime variable?
Click to expand...
P.S. My codebehind is VB.net in vs2008 sp1.
Click to expand...

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.Attribute("dt"), DateTime)
Console.WriteLine(dt)
 
Back
Top