Get records from last hour

Question

I have this query:

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 = ???????

I am using Sybase adaptive server anywhere and trying to get records for the last hour.

score 50 · Accepted Answer · answered Nov 02 '13 at 16:54

50

try this !!

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 > DATEADD(HOUR, -1, GETDATE())

answered Nov 02 '13 at 16:54

vhadalgi

7,027
6
38
67

Makes sense. Thanks. – Christopher Jul 26 '17 at 17:49

score 4 · Answer 2 · edited Mar 13 '14 at 07:25

4

Try below query:

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 >= (sysdate-1/24);

edited Mar 13 '14 at 07:25

Hashem Qolami

97,268
26
150
164

answered Nov 02 '13 at 16:25

user3540800

41
1

Bonez024 · Answer 3 · 2019-02-12T17:49:04.700

Similar to TeamDataViz's answer. Just a little more readable IMO.

SELECT Field1, OrderFor, Writeback, Actshipdate, Orderstatus, receivedate, receivetime
FROM orderinfo, shippinginfo
WHERE orderinfo.orderid = shippinginfo.orderid
AND shippinginfo.custid = '37782'
WHERE receivedate BETWEEN DATEADD(HOUR,-1,GETDATE()) AND CAST(GETDATE() AS DATE)

The WHERE Clause becomes even easier if you only wish to focus on records by Past DAY

WHERE receivedate > GETDATE() - 12

Get records from last hour

3 Answers3

Linked