title: timestamp to XML and then from XML, how?
body: <p>people! i need some help in this
  I have a TABLE with timestamp field and i want to use WCF service to transfer data into other SQL Server
  Now, I try to simulate this, using "for xml"</p>
  
  <pre><code>DECLARE @aa XML
  DECLARE @idoc int
  SET @aa =(select * from db_table for xml auto, elements, root('root'), type)
  </code></pre>
  
  <p>select @aa returns</p>
  
  <pre><code>&lt;root&gt;
  &lt;Person&gt;
   &lt;preson_id&gt;1&lt;/preson_id&gt;
   &lt;Name&gt;Иван&lt;/Name&gt;
   &lt;Surname&gt;Иванов&lt;/Surname&gt;
   &lt;BurthDate&gt;1915-05-03&lt;/BurthDate&gt;
   &lt;guid&gt;2E739E87-3CA4-4ED8-ADD0-8B59957668B8&lt;/guid&gt;
   &lt;version&gt;AAAAAAAAB9E=&lt;/version&gt;
  &lt;/Person&gt;
  &lt;Person&gt;
   &lt;preson_id&gt;2&lt;/preson_id&gt;
   &lt;Name&gt;Николай&lt;/Name&gt;
   &lt;Surname&gt;Николаев&lt;/Surname&gt;
   &lt;BurthDate&gt;2005-03-05&lt;/BurthDate&gt;
   &lt;guid&gt;BDC41C59-D70F-4B70-954E-4918B9516AF8&lt;/guid&gt;
   &lt;version&gt;AAAAAAAAB9I=&lt;/version&gt;
  &lt;/Person&gt;
  &lt;Person&gt;
   &lt;preson_id&gt;3&lt;/preson_id&gt;
   &lt;Name&gt;Максим&lt;/Name&gt;
   &lt;Surname&gt;Максимов&lt;/Surname&gt;
   &lt;BurthDate&gt;1845-11-15&lt;/BurthDate&gt;
   &lt;guid&gt;740E57F3-56BA-48B8-92AF-978D7B1D2712&lt;/guid&gt;
   &lt;version&gt;AAAAAAAAB9M=&lt;/version&gt;
  &lt;/Person&gt;
  &lt;/root&gt;
  </code></pre>
  
  <p>It's look good for the first look, but when i try to take data from xml, timestamp values looks not good(</p>
  
  <pre><code>EXEC sp_xml_preparedocument @idoc OUTPUT, @aa
  SELECT * FROM OPENXML (@idoc, '/root/Person',2)
     WITH db_table
  </code></pre>
  
  <p>How can i take from xml timestamp values in source look?</p>
  
  <p>Sorry for my not good English)))</p>