title: mysql time comparison
body: <p>I have job_start and job_end times and timediff will give me the time difference. Now I want to see if that job took more than 2 hrs 30 min. How do I compare it? I am getting errora if I do it like this: </p>
  
  <pre><code>timediff(job_start,job_end)&gt; '2:30:00'    
  timediff(job_start,job_end)&gt; time(2:30:00)   
  timediff(job_start,job_end)&gt; time_format(2:30:00)
  </code></pre>
  
  <p>Nothing of the above syntax is working.</p>