域名頻道IDC知識庫
sqlserver時間函數DATEDIFF介紹
select * from ShopOrder where datediff(week,ordTime,getdate()-1)=0?? //查詢當天日期在一周年的數據 select * from ShopOrder where dated...
標簽：SQL必知必會
IDC知識庫
IDC領域專業知識百科平臺
IDC領域專業知識百科平臺
select * from ShopOrder where datediff(week,ordTime,getdate()-1)=0?? //查詢當天日期在一周年的數據 select * from ShopOrder where dated...