Jaimal Chohan

Posts Tagged ‘Serialization

.NET XML Serialization & T-SQL XML – DateTime

Posted by: jaimalchohan on: April 29, 2008

Today whilst trying to validate an XML document in Sql Server 2005, which had been passed in as a paramater from .Net, I came accross an issue with DateTime serialization.
XML Date Time Sepcification

The W3C XML Schema Scpeification specifies that a valid datetime is the following

2008-04-28T22:45:32+01:00

The first portion before the ‘T’ is obviously the date. [...]

.NET XML Serialization & T-SQL XML – DateTime

Posted by: jaimalchohan on: April 29, 2008

Today whilst trying to validate an XML document in Sql Server 2005, which had been passed in as a paramater from .Net, I came accross an issue with DateTime serialization.
XML Date Time Sepcification

The W3C XML Schema Scpeification specifies that a valid datetime is the following

2008-04-28T22:45:32+01:00

The first portion before the ‘T’ is obviously the date. [...]