title: Access Date Time convert to string. Time is stored as Military, Don't want to convert
body: <p>I am writing a SQL query for MS Access.</p>
  
  <p>The two fields are DateTime. The start/end time are 22:30/6:30</p>
  
  <p>When I run the following query</p>
  
  <pre><code>SELECT cDate(Format(table1.BeginTime,"hh:mm")),
  </code></pre>
  
  <p>I get 10:30 PM instead of 22:30. I do not want to convert to 12hrs format. How do I keep the Miliary time format?</p>