title: Convert 24-Hour format datetime to varchar Sql Server 2008
body: <p>I have a problem in converting sql server 2008 datetime to varchar,</p>
  
  <pre><code>Select convert(varchar(20),convert(datetime, '2013-12-11 00:59:00.000'))
  </code></pre>
  
  <p>the result is <code>Dec 11 2013 12:59AM</code> but I need it to be actually <code>Dec 11 2013 00:59AM</code> as in the database dates are of 24-Hour format.</p>
  
  <p>How can I correct the query?</p>