title: The conversion of a datetimeoffset data type to a datetime data type resulted in an out-of-range value
body: <p>Using SQL Server 2008.I have a table called User which has a column <code>LastLogindata</code> with <code>datetimeoffset</code> datatype</p>
  
  <p>The following query works on production server but not on replication server.</p>
  
  <pre><code>select top 10 CAST(LastLoginDate AS DATETIME)  from User.
  </code></pre>
  
  <p>I am getting the following error.The conversion of a datetimeoffset data type to a datetime data type resulted in an out-of-range value.</p>
  
  <p>Thanks</p>