title: Get records from last hour
body: <p>I have this query:</p>
  
  <pre><code>SELECT Field1, OrderFor, Writeback, Actshipdate, Orderstatus, receivedate, receivetime
  FROM orderinfo, shippinginfo
  WHERE orderinfo.orderid = shippinginfo.orderid
  AND shippinginfo.custid = '37782'
  AND receivedate =  DATE(NOW())
  AND receivetime = ???????
  </code></pre>
  
  <p>I am using Sybase adaptive server anywhere and trying to get records for the last hour.</p>