title: SQL Server : inserting datetime into table
body: <p>I have a table:</p>
  <pre><code>CREATE TABLE [dbo].[667788]
  (
      a NVARCHAR(100),
      b NVARCHAR(100),
      c NVARCHAR(100),
      d NVARCHAR(100),
      e NVARCHAR(100),
      f NVARCHAR(100),
      t1 DATETIME,
      t2 DATETIME
  )
  </code></pre>
  <p>I'm trying to insert the following values:</p>
  <pre><code>('x','y','m','2','a','c','16/11/2012 00:00:00','06/08/2013 00:00:00'),
  </code></pre>
  <p>but I get an error:</p>
  <blockquote>
  <p>The conversion of a varchar data type to a datetime data type resulted in an out-of-range value</p>
  </blockquote>
  <p>Does anyone know any way around it in the format I have provided?</p>