摘要:
下文讲述sqlserver获取指定日期到今日的年份及月份之和,如下所示;
实现思路:
1.根据datediff计算出入职日期同当前日期间隔的月份
2.间隔月份除以12得到的入职年份信息
3.间隔月份同12取余得到的信息为入职月份信息
例:
根据入职日期计算出一个员工入职的年份及月份
create table [maomao365.com]
(keyId int identity(1,1),
ruZhiDate date)
go
insert into [maomao365.com]
(ruZhiDate)values
('1998-12-1'),('2012-1-1'),
('2013-2-1')
go
select *,
datediff(month,ruZhiDate,getdate())
/12 as [入职年份],
datediff(month,ruZhiDate,getdate())
%12 as [入职月份]
from
[maomao365.com]
go
truncate table [maomao365.com]
drop table [maomao365.com]
mssql_sqlserver根据入职日期计算出入职的总年份及月份的示例分享