摘要:
–查询某年的数据select * from table where YEAR(createTime) = 2018; –查询某月的数据 将数据库中的时间字段格式改为字符串格式。select * from combine where CONVERT(varchar(7),create_time, 12 阅读全文
摘要:
select * from ShopOrder where datediff(week,ordTime,getdate()-1)=0 //查询当天日期在一周年的数据 select * from ShopOrder where datediff(day,ordTime,getdate()-1)=0 / 阅读全文