SQL Sever跨月数据，跨年数据

Question

当一个店的合同截止日期是月末那天时，它在月末那天仍是合同，实际过期日期为下个月1日。要统计即将过期的门店怎么统计呢？SQL

Answer 1

用DATEADD 函数。下面是合同日期在这个区间内的都找出来
select 合同日期 between DATEADD(dd,-5,GETDATE()) and  DATEADD(dd,1,GETDATE())

Answer 2

测试数据
EndDate
2013-05-31 00:00:00
2013-06-01 00:00:00
2013-06-02 00:00:00
2013-06-03 00:00:00
2013-06-04 00:00:00
2013-06-05 00:00:00
2013-06-06 00:00:00
2013-06-07 00:00:00
2013-06-08 00:00:00
2013-06-09 00:00:00
2013-06-10 00:00:00
2013-06-11 00:00:00
2013-06-12 00:00:00
2013-06-13 00:00:00
2013-06-14 00:00:00
2013-06-15 00:00:00
2013-06-16 00:00:00
2013-06-17 00:00:00
2013-06-18 00:00:00
2013-06-19 00:00:00
2013-06-20 00:00:00
2013-06-21 00:00:00
2013-06-22 00:00:00
2013-06-23 00:00:00
2013-06-24 00:00:00
2013-06-25 00:00:00
2013-06-26 00:00:00
2013-06-27 00:00:00
2013-06-28 00:00:00
2013-06-29 00:00:00
2013-06-30 00:00:00
我想选择6月份数据的时候能够带上2013-05-31 00:00:00的数据并且将2013-06-30 00:00:00数据放置到7月份的查询数据中

Answer 3

select * from tab where month(dateadd(day,1,合同到期))='6'