2013-3-8 8:00:00 2013-3-24 17:00:00
SELECT begintime,endtime FROM empleave
WHERE (? BETWEEN MONTH(begintime) AND MONTH(endtime) AND YEAR(begtime)=?
1,查询的月
2,查询的年
如果日期如下2013-11-8 8:00:00 2014-3-24 17:00:00
请问SQL如何查询出跨年的相关数据 如果我需要2014-2月,2013-12月等
SELECT begintime,endtime FROM empleave
WHERE (? BETWEEN MONTH(begintime) AND MONTH(endtime) AND YEAR(begtime)=?
1,查询的月
2,查询的年
如果日期如下2013-11-8 8:00:00 2014-3-24 17:00:00
请问SQL如何查询出跨年的相关数据 如果我需要2014-2月,2013-12月等
select * from (
SELECT begintime,endtime FROM empleave
WHERE (? BETWEEN MONTH(begintime) AND MONTH(endtime) AND YEAR(begtime)=?
) a where datediff(year,begintime,endtime)='1'