title: Conversion failed when converting date and/or time from character string while inserting datetime
body: <p>I was trying to create a table as follows,</p>
  
  <pre><code>create table table1(date1 datetime,date2 datetime);
  </code></pre>
  
  <p>First I tried inserting values as below,</p>
  
  <pre><code>insert into table1 values('21-02-2012 6:10:00 PM','01-01-2001 12:00:00 AM');
  </code></pre>
  
  <p>It has given error saying,</p>
  
  <blockquote>
    <p><em>Cannot convert varchar to datetime</em></p>
  </blockquote>
  
  <p>Then I tried below format as one of the post suggested by our stackoverflow,</p>
  
  <pre><code>insert into table1 values(convert(datetime,'21-02-2012 6:10:00 PM',5)
                            ,convert(datetime,'01-01-2001 12:00:00 AM',5));
  </code></pre>
  
  <p>But am still getting the error saying,</p>
  
  <blockquote>
    <p><em>Conversion failed when converting date and/or time from character string</em></p>
  </blockquote>
  
  <p>Any suggestions?</p>