年月分开的sql、

Question

两个字段OA_PAYSLIPS.YEAR，OA_PAYSLIPS.MONTH
表：OA_PAYSLIPS
想查出来日期在 '2015-01' 
 '2015-11' 
之间的数据，sql怎么写？
OA_PAYSLIPS.YEAR，OA_PAYSLIPS.MONTH
是int类型

---

please verify my account

Answer 1

OA_PAYSLIPS.YEAR=2015 and OA_PAYSLIPS.MONTH between 1 and 11

Answer 2

跨年考虑使用

OA_PAYSLIPS.YEAR * 100 + OA_PAYSLIPS.MONTH between 201411 and 201511

Answer 3

跨年考虑使用

OA_PAYSLIPS.YEAR * 100 + OA_PAYSLIPS.MONTH between 201411 and 201511

传过来的条件是2015-01，怎么变成201501

---

please verify my account

Answer 4

有跨年查询

---

please verify my account

Answer 5

cast(OA_PAYSLIPS.YEAR as nvarchar) +'-'+ right('00'+cast(OA_PAYSLIPS.MONTH as nvarchar),2)>='2015-01'

and

cast(OA_PAYSLIPS.YEAR as nvarchar) +'-'+ right('00'+cast(OA_PAYSLIPS.MONTH as nvarchar),2)<='2015-11'

---

http://feiyun0112.cnblogs.com/