title: Convert a 12 hour format to 24 hour format in sql server
body: <p>there  are date values in the below format,in one of the sql server 2000 tables</p>
  
  <pre><code>10/1/2013 10:39:14 PM
  10/1/2013 6:39:04  PM
  10/1/2013 8:19:31  AM
  10/1/2013 3:35:40  AM
  </code></pre>
  
  <p>how to convert the above format data values into a 24hour date format,as shown below</p>
  
  <pre><code>10/1/2013 10:39
  10/1/2013 18:39
  10/1/2013 8:19
  10/1/2013 3:35
  </code></pre>