title: Android - Time Comparison "hh:mm:ss a" format
body: <p>"I try to compare two time in "hh:mm:ss a" format. But it not really work in what I think. I googled but couldn't find a proper answer. Sorry cause I'm new to programming."</p>
  
  <p>I try to compare the time like this:</p>
  
  <pre><code>String strSQL = "SELECT * FROM " + TABLE_SCHEDULE + " WHERE lecturer_id=? AND schedule_day=? AND schedule_endtime &gt; ?";
  </code></pre>
  
  <p><strong>schedule_endtime > ?</strong></p>
  
  <p>However, the comparison has ignored the AM/PM which caused the result become like this:
  <strong>eg.  12:00:00 PM is bigger than 02:00:00 PM.</strong></p>
  
  <p>Hope that you all can give some tips or provide some solution. Appreciate it.</p>