Sqlserver语句获取本周、上一周、本月数据 |
您所在的位置:网站首页 › sqlserver获取当前时间 › Sqlserver语句获取本周、上一周、本月数据 |
sql语句获取本周、上一周、本月数据
获取周数据 1 本周 2 select * from table1 where datediff(week,时间字段,getdate()) = 0 3 上周 4 select * from table1 where datediff(week,时间字段,getdate()) = 1 5 下周 6 select * from table1 where datediff(week,时间字段,getdate()) = -1获取月数据 1 本月 2 select * from table1 where datediff(mm,时间字段,getdate()) = 0 3 上月 4 select * from table1 where datediff(mm,时间字段,getdate()) = 1 5 下月 6 select * from table1 where datediff(mm,时间字段,getdate()) = -1昨天: dateadd(day,-1,getdate())明天: dateadd(day,1,getdate())上月: month(dateadd(month,-1,getdate()))本月: month(getdate())下月: month(dateadd(month,1,getdate()))昨天: select * from table1 where datediff(dd,时间字段,getdate()) = 1明天: select * from table1 where datediff(dd,getdate(),时间字段) = -1最近七天: select * from table1 where datediff(dd,时间字段,getdate()) |
今日新闻 |
推荐新闻 |
CopyRight 2018-2019 办公设备维修网 版权所有 豫ICP备15022753号-3 |