title: Get 24 hour format time from 12 hour format time in MySQL / Read 12 hour format string into time so I can convert it to another time
body: <p>I'm on this page now reading documentation...
  <a href="http://dev.mysql.com/doc/refman/5.5/en/date-and-time-functions.html#function_date-format" rel="nofollow noreferrer">Data time function</a>
  for this</p>
  <pre><code>SELECT TIME_FORMAT(&quot;9:45 PM&quot;, &quot;%H:%i:%s&quot;)
  </code></pre>
  <p>Result what I get</p>
  <pre><code>09:45:00
  </code></pre>
  <p>I think what should I get is</p>
  <pre><code>21:45:00
  </code></pre>
  <p>How to achieve this? I am on the documentation page but not getting anything.
  Maybe I should say how do I read the string &quot;9:45 PM&quot; into time and make it in a time and then convert it to what I want?</p>