title: The conversion of a nvarchar data type to a datetime
body: <p>I have execute new query as below:    </p>
  
  <pre><code>alter table tenancy_extend_old alter column createdate datetime
  </code></pre>
  
  <p>but it show messages error as below:
  Msg 242, Level 16, State 3, Line 1
  The conversion of a nvarchar data type to a datetime data type resulted in an out-of-range value.
  The statement has been terminated.</p>
  
  <p>Please help me. thanks</p>