title: Wrong time for same timezone in SQL Server 2005
body: <p>I am passing param of type XML as a stored procedure param succesfully. I have no problems handling all the data from XML, but I discovered that dates from XML are not retrieved properly.</p>
  
  <p>For example, <code>2013-03-14T15:14:53.598438+01:00</code> is now <code>2013-03-14 14:14:00</code>. It seems that SQL is calculating <code>+1</code> to display time.</p>
  
  <p>I am using following T-SQL to get date from xml</p>
  
  <pre><code>select 
     A.B.value('xs:dateTime((ConfirmationDate)[1])', 'smalldatetime') as ConfirmationDate
  FROM    
     @XML.nodes('/ArrayOfPreOrder/PreOrder/confirmationinfo/ConfirmationInfo') A(B)) as ConfirmationDate
  </code></pre>
  
  <p>How can I correct this issue? Both server and SQL Server are in the same timezone.</p>