標(biāo)簽：sqlserver取時(shí)間小時(shí)

2024-04-15zhaods閱讀(753)贊(11)

select * from ShopOrder where datediff(week,ordTime,getdate()-1)=0?? //查詢(xún)當(dāng)天日期在一周年的數(shù)據(jù) select * from ShopOrder where dated...