select u.fullname ,u.city,u.prov,u.zone,o.id ,o.ondate ,d.prodname from orders as o left join userinfo as u on o.memberid=u.memberid left join orderdetail as d on o.id = d.orderid where o.memberid ='CN60008767' and o.addOrderStat =2 and o.ordertype = 1 这是一条可执行的语句,我想加个条件:
需求如下:orders 表里有个ondate字段,如字段值是2008-01-01 我想查询他48小时内的记录。请问条件怎么加上去
AND DATEDIFF(H,ondate,GETDATE())<=48
DATEDIFF(HOUR,ondate,GETDATE())
from orders as o
left join userinfo as u on o.memberid=u.memberid
left join orderdetail as d on o.id = d.orderid
where o.memberid ='CN60008767' and o.addOrderStat =2 and o.ordertype = 1
and DATEDIFF(hh,o.ondate,GETDATE())<=48
select u.fullname ,u.city,u.prov,u.zone,o.id ,o.ondate ,d.prodname from orders as o left join userinfo as u on o.memberid=u.memberid left join orderdetail as d on o.id = d.orderid where o.memberid ='CN60008767' and o.addOrderStat =2 and o.ordertype = 1 and DATEDIFF(HOUR,o.ondate,getdate())<=48有错误呢
select u.fullname ,u.city,u.prov,u.zone,o.id ,o.ondate ,d.prodname
from orders as o
left join userinfo as u on o.memberid=u.memberid
left join orderdetail as d on o.id = d.orderid
where o.memberid ='CN60008767' and o.addOrderStat =2 and o.ordertype = 1
and DATEDIFF(o.ondate,Now()) <=2郁闷似乎是这样