获取上一小时的记录

作者: 狗头军师
发布时间: 2025-02-11 07:50:58 (11天前)

2 条回复

1#
回复此人
v-star*위위 | 2020-08-07 15-03

试试这个！！ ``` 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()) ```

编辑

登录后才能参与评论