title: How change format date in SQL Server or how true insert datetime in SQL Server by c#
body: <p>I have string <code>date="20130613070000+1000"</code> I convert to datatime by using:</p>
  
  <pre><code>date_dt = DateTime.ParseExact(date, "yyyyMMddHHmmsszzz", null, DateTimeStyles.None);
  </code></pre>
  
  <p>results its <code>date_dt=13/06/2013 12:00:00 AM</code> </p>
  
  <p>I insert into database SQL Server using </p>
  
  <pre><code>insert into date (startdate) VALUES ('13/06/2013 12:00:00 PM')
  </code></pre>
  
  <p>I have a problem - I get an error:</p>
  
  <blockquote>
    <p>Msg 242, Level 16, State 3, Line 6<br>
    The conversion of a varchar data type to a datetime data type resulted in an out-of-range value.</p>
  </blockquote>
  
  <p>What's the solution for <code>dt_date</code> convert with fomat <code>MM/dd/yyy</code> ?</p>