I extracted xml using "for xml" clause from Production.ProductCategory table in AdventureWorks.
The ModifiedDate is extracted as "1998-06-01T00:00:00
When I try to load this XML (using BulkLoad) into another sql server instance, I get "Invalid character value for cast specification
My xsd schema looks like this:
<xs:element name="ModifiedDate" sql:field="ModifiedDate" type="xs:dateTime"/>
What works as the date value:
What else does not work as date value:
I would appreciate any pointers.