title: Mysql date comparision (greater than equal) without leading zeros
body: <p>I had to do some date comparision and return a dataset. PHP sent the current date time, with a time with non leading zeros (8:00:00) for 8 am instead of (08:00:00). The case where there were no leading zeros, was giving wrong results. Can someone explain why ? </p>
  
  <p>To test, run this <code>SELECT IF(DATE_ADD('2011-03-20', INTERVAL '08:05:00' HOUR_SECOND) &gt;= '2011-03-20 8:00:00',"yes","No")</code></p>
  
  <p>result: No</p>
  
  <p>AND </p>
  
  <p><code>SELECT IF(DATE_ADD('2011-03-20', INTERVAL '08:05:00' HOUR_SECOND) &gt;= '2011-03-20 08:00:00',"yes","No")</code></p>
  
  <p>result: Yes</p>
  
  <p>shouldn't both give the result : "Yes" </p>
  
  <p>Is it doing string comparison for a non leading zero ? </p>