查询表中昨天和今天的数据

select * from tbOutData where datediff(day,datCashTime,getdate())
between datediff(day,(getdate()-1),getdate()) and datediff(day,getdate(),getdate())

posted @   江宁织造  阅读(203)  评论(0编辑  收藏  举报
努力加载评论中...
点击右上角即可分享
微信分享提示