title: How to select values from 2 hours ago from now
body: <p>I am not having much knowledge on mysql queries.. and i'm trying to get values from database from last two hours from now ..I have searched about it and i have found some related posts too.. but unfortunately i am unable to implement the logic.. please help me solve this issue.. </p>
  
  <p>here is the mysql query</p>
  
  <pre><code>select * 
  from `ordermaster` 
  where ((
  `ordermaster`.`Pick_date`
   = curdate())
   and (`ordermaster`.`Pick_time`
   &lt;= (now() - interval 2 hour)) 
  and (`ordermaster`.`Status` 
  = 2))
  </code></pre>
  
  <p>were, Pick_Date  = "2017-04-19" (today date) and Pick_Time =  "10:00:00" (24 hours format)</p>