where datediff(dy,YourDateCol,getdate())=1
where datediff(ww,YourDateCol,getdate())=1
where datediff(yy,YourDateCol,getdate())=1
where datediff(ww,YourDateCol,getdate())=1
where datediff(yy,YourDateCol,getdate())=1
前一天应该是
where datediff(dy,-1,getdate())
对不对,这样能满足上面的要求吗??
—————————————————————————————————
笨鸟未飞
where datediff(dy,YourDateCol,getdate())=1
周
where datediff(ww,YourDateCol,getdate())=1
年
where datediff(yy,YourDateCol,getdate())=1
select * from xs_xsd where datediff(dy,kdrq,getdate())=1
kdrq是指开单日期的字段名,搜索不出昨天的数据—————————————————————————————————
笨鸟未飞