xml, DateTime conversions and DateTime fields
 

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.

Re: xml, DateTime conversions and DateTime fields
 

On 25 Wrz, 12:05, "Andy B" <a_bo...@sbcglobal.net> wrote:
> 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

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

--

Martin Honnen --- MVP XML
http://JavaScript.FAQTs.com/