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)