![](http://chouwenlao.cn/docs/wp-content/themes/dux/img/thumbnail.png)
sqlserver時間函數(shù)DATEDIFF介紹
select * from ShopOrder where datediff(week,ordTime,getdate()-1)=0?? //查詢當(dāng)天日期在一周年的數(shù)據(jù) select * from ShopOrder where dated...
select * from ShopOrder where datediff(week,ordTime,getdate()-1)=0?? //查詢當(dāng)天日期在一周年的數(shù)據(jù) select * from ShopOrder where dated...