SQL - MS-SQL Server / 疑难问题

select a.name as HYLBname,b.Kh as kh,b.name as name,b.tel as tel,b.csrq as csrq ,b.idate as idate
from hylx a inner join hyxx b 
on a.id=b.hylb and csrq in(select csrq from HYXX where 
abs(datediff(dd,dateadd(yy,-datediff(yy,0,csrq),csrq),dateadd(yy,-datediff(yy,0,getdate()),getdate())))<=10
)and ZT=0

  CSRQ只要月份和日期！

---

CSRQ只要月份和日期！
是什么意思,日期不代表月分?

SELECT CONVERT(CHAR(10),GETDATE(),120)
?

---

SQL code:
select a.name as HYLBname,b.Kh as kh,b.name as name,b.tel as tel,right(convert(varchar(10),b.csrq,23),5) as csrq ,b.idate as idate
from hylx a inner join hyxx b
on a.id=b.hylb and csrq in(select csrq from HYXX where
abs(datediff(dd,dateadd(yy,-datediff(yy,0,csrq),csrq),dateadd(yy,-datediff(yy,0,getdate()),getdate())))<=10
)and ZT=0

---

引用

CSRQ只要月份和日期！
是什么意思,日期不代表月分?

SELECT CONVERT(CHAR(10),GETDATE(),120)
?

  只要MONTH和DAY!

---

SELECT right(CONVERT(CHAR(8),GETDATE(),112),4)