title: Sql Server how to insert date into column with date datatype
body: <p>I am trying to insert birthday date into column date within <code>Sql Server 2008 r2</code>
  db I tried to pass it as below but none of them are worked out</p>
  
  <p><a href="https://i.stack.imgur.com/CKejH.png" rel="nofollow noreferrer"><img src="https://i.stack.imgur.com/CKejH.png" alt="enter image description here"></a></p>
  
  <pre><code>INSERT INTO t1 (birthday) VALUES (cast(08/12/2010 as date))
  </code></pre>
  
  <blockquote>
    <p>Msg 529, Level 16, State 2, Line 1 Explicit conversion from data type
    int to date is not allowed.</p>
  </blockquote>
  
  <pre><code>INSERT INTO t1 (birthday) VALUES (20100812)
  </code></pre>
  
  <blockquote>
    <p>Operand type clash: int is incompatible with date</p>
  </blockquote>
  
  <pre><code>INSERT INTO t1 (birthday) VALUES (20100812)
  
  INSERT INTO t1 (birthday) VALUES ('20100812')
  </code></pre>
  
  <blockquote>
    <p>Error converting data type varchar to numeric.</p>
  </blockquote>
  
  <pre><code>INSERT INTO t1 (birthday) VALUES ('2010-08-12')
  </code></pre>
  
  <blockquote>
    <p>Error converting data type varchar to numeric.</p>
  </blockquote>