SQL Server 获取本周,本月,本年等时间内记录
摘要:datediff(week,zy_time,getdate())=0 //查询本周 datediff(month,zy_time,getdate())=0 //查询本月 本季:select * from table where datediff(qq,C_CALLTIME,getdate())=0前
阅读全文
posted @ 2019-09-18 09:58
posted @ 2019-09-18 09:58
posted @ 2019-09-06 22:44
posted @ 2019-09-05 12:59
posted @ 2019-09-02 13:00