title: Syntax error converting character string to smalldatetime data type
body: <p>Receiving this error in SQL Server 2000 when trying to do an insert from one database to another on the same server. The columns on both tables are smalldatetime and allow nulls.</p>
  
  <p>In short, my code is:</p>
  
  <pre><code>INSERT INTO DB2..Table2
  SELECT BirthDate, RefDate, Email, FirstName, LastName, ExitDate
  FROM DB1..Table1
  </code></pre>
  
  <p>And the error is:</p>
  
  <pre><code>Msg 295, Level 16, State 3, Line 1
  Syntax error converting character string to smalldatetime data type.
  </code></pre>
  
  <p>Why am I getting this error when the source is a smalldatetime?</p>