In the article you had written that we need to give time zone information while creating xml for a date or time field. In this case when we use xpath query to get the value of a date field via following query I am getting a error message.

   x.item.value('Employee\@ReportingTime[1]', 'Datetime') AS ReportingTime

   Let say ReportingTime as attribute for a Employee element.

That message is because I am casting a value like '1975-03-14+05:30' in Datetime in Sql Server and sql server donot store timezone information in the field itself.

I have only option to use string datatype in schema

Is there any other method ....