sqlserver日期格式化以及间隔天数

Laughing

2018-07-02 / 0 评论 / 1,393 阅读 / 正在检测是否收录...

07/02

温馨提示：

本文最后更新于2020年09月25日，已超过1575天没有更新，若内容或图片失效，请留言反馈。

select re.orgname as dwmc,re1.orgname as bmmc, zgzd.lszgzd_zgxm as zgxm, 
Cast(year(cosign.ssrq) as varchar(4)) + '年' +Cast(month(cosign.ssrq) as varchar(2)) + '月' +Cast(day(cosign.ssrq) as varchar(2)) + '日'   as ssrq, 
Cast(year(cosign.zzrq) as varchar(4)) + '年' +Cast(month(cosign.zzrq) as varchar(2)) + '月' +Cast(day(cosign.zzrq) as varchar(2)) + '日' as zzrq   from hrcosign cosign
left join  hrzgzd zgzd on zgzd.hrzgzd_nm = cosign.parentnm
left join  hrorgrelation re on re.dimensionnm='dd01' and re.parentnm=zgzd.hrzgzd_hrdwnm
left join  hrorgrelation re1 on re1.dimensionnm='dd01' and re1.parentnm=zgzd.hrzgzd_hrbmnm
where contracttype='0' 
and DateDiff(DAY,Convert(varchar(20),zzrq,23),Convert(varchar(20),getdate(),23)) <= 60

Sql Server