工龄计算

最新推荐文章于 2021-02-19 04:30:12 发布

zenowolf

最新推荐文章于 2021-02-19 04:30:12 发布

阅读量515

点赞数

本文链接：https://blog.csdn.net/raineo/article/details/4793013

版权

declare @beginDate datetime
declare @endDate datetime
set @beginDate='2009/12/02'
set @endDate='2012/12/01'
select  cast(case when day(@beginDate)<= day(@endDate)
       then 0
       else -1
       end
       +datediff(month,@beginDate,@endDate)/12 as varchar)+'year'--年
+right('0'+cast((case when day(@beginDate)<= day(@endDate)
       then 0
          else -1
          end
          +datediff(month,@beginDate,@endDate))%12 as varchar ),2)+'month'--月
+right('0'+cast(case    when day(@beginDate)<= day(@endDate)
       then day(@endDate)-day(@beginDate)
       else datediff(day,@beginDate,dateadd(month,1,@beginDate))+day(@endDate)-day(@beginDate)
       end as varchar
       ),2)+'day'--日