title: SQL Convert Nvarchar(255) to DateTime problem
body: <p>I'm using SQL server 2008.</p>
  
  <p>I have 2 Tables: Table 1 and Table 2.</p>
  
  <p>Table 1 has 1 column called: OldDate which is nvarchar(255), null<br>
  Table 2 has 1 column called: NewDate which is datetime, not null </p>
  
  <p>Example data in Table 1:</p>
  
  <pre><code>26/07/03
  NULL
  NULL
  23/07/2003
  7/26/2003
  NULL
  28/07/03
  </code></pre>
  
  <p>When i try CAST(OldDate as datetime)</p>
  
  <p>I get this error:</p>
  
  <blockquote>
    <p>Arithmetic overflow error converting
    expression to data type datetime.</p>
  </blockquote>
  
  <p>I need to insert OldDate into NewDate with no errors. I can't skip some rows.</p>