It depends on how you serialise, if you implement IXmlSerializable and use 
XmlConvert then one of the XmlDateTimeSerializationMode values may help.

-- 

Joe Fawcett (MVP - XML)

http://joe.fawcett.name

"Sugandh Jain" <sugandh.jain@n...> wrote in message 
news:ek$3LYtoHHA.4124@T......
> Hi,
>
> I am serializing a collection of objects of a Type(Class).
> The class contians a DateTime type property in it.
>
> Now, I am serializing this collection.
> For some of the DateTime values, I get the DateTime with the TimeZone 
> Information included in the XML.
> Like this   ...   2007-05-30T16:12:55.79239Z
>
> Now, I dont want this in my XML, as it creates problem while converting 
> this value to datetime in SQL SERVER.
>
> I an using .Net 2.0 and SQL Server 2005.
>
> One of the the following to solutions is required.
>
> 1. The XML generated by serialization does not have the time zone 
> information with for the field.
> or
> 2. Handling the conversion of a string representing this DateTime with 
> TimeZone information in SQL Server to convert it to SQL Date Time.
>
>
> I need some solution for this urgently.
>
> Regards
> Sugandh
>
>
>