title: Convert dd-mm-yyyy to mm/dd/yyyy
body: <p>I have a <code>varchar(200)</code> column called <code>Submit_Date</code> and I am trying to convert it to MM/DD/YYYY format. When I do that I get the following error:</p>
  
  <blockquote>
    <p>Msg 242, Level 16, State 3, Line 1<br>The conversion of a varchar data type to a datetime data type resulted in an out-of-range value.</p>
  </blockquote>
  
  <p>Sample Data of the table is:</p>
  
  <pre><code>Submit_Date
  -----------------------
  27-09-2013 16:15:00 CST
  30-09-2013 16:30:24 CST
  27-09-2013 10:03:46 CST
  </code></pre>
  
  <p>I tried the following:</p>
  
  <pre><code>Select Convert(datetime,Submit_date,101) from dbo.Tickets
  </code></pre>