title: How to compare datetime2 with datetime
body: <p>I need compare property datetime2 that one database with property datetime that other database because I don't find method for convert datetime to datetime2.</p>
  
  <p>I test this sentence:</p>
  
  <pre><code>select CAST(FechaAlta AS datetime) from tutors
  </code></pre>
  
  <p>but return this error message:</p>
  
  <blockquote>
    <p>The conversion of a datetime2 data type to a datetime data type resulted in an out-of-range value.</p>
  </blockquote>