title: How to insert datetime from string in sql server
body: <p>Lets say i have a string like Below</p>
  
  <pre><code>string dt = "2/14/2014 11:59:59 PM";
  </code></pre>
  
  <p>now i want to insert this in sql server 2012.
  i am trying with the below query</p>
  
  <pre><code>INSERT INTO Some_Info(date_colm1,date_colm2) VALUES(CONVERT(datetime, '2/14/2014 11:59:59 PM'),CONVERT(datetime, '2/14/2014 11:59:59 PM') );
  </code></pre>
  
  <p>i'm getting output like below</p>
  
  <pre><code>Conversion failed when converting date and/or time from character string.
  </code></pre>
  
  <p>what seems to be the problem? am i missing something?</p>