title: mysql search by time on time stamp
body: <p>I am stuck with this issue for a while now any solutions are welcomed.</p>
  
  <p>I have a table in MySQL and i am storing a <code>timestamp</code>.</p>
  
  <p>Now lets say if i search on the basis of only date it works.</p>
  
  <pre><code>SELECT *
  FROM   table
  WHERE  timestamp &gt; "2012-03-12";
  </code></pre>
  
  <p>this fetches all data where timestamp value is greater than 2012-03-12 00:00:00.</p>
  
  <p>what i want is a query like this :</p>
  
  <pre><code>SELECT *
  FROM   table
  WHERE  timestamp &gt; "10:20:09";
  </code></pre>
  
  <p>where all records with tie greater than 10:20:09 is fetched irrespective of the date.</p>