SELECT cardID,
birthdate,
( DATEPART(yyyy, GETDATE()) - DATEPART(yyyy, birthdate) )
/ 4 '闰年次数(不包含GETDATE())',
DATEDIFF(d, birthdate, GETDATE()),
--距离出生日期的天数
DATEDIFF(d, birthdate, GETDATE()) % 365
- ( DATEPART(yyyy, GETDATE()) - DATEPART(yyyy, birthdate) )
/ 4
FROM Members
birthdate,
( DATEPART(yyyy, GETDATE()) - DATEPART(yyyy, birthdate) )
/ 4 '闰年次数(不包含GETDATE())',
DATEDIFF(d, birthdate, GETDATE()),
--距离出生日期的天数
DATEDIFF(d, birthdate, GETDATE()) % 365
- ( DATEPART(yyyy, GETDATE()) - DATEPART(yyyy, birthdate) )
/ 4
FROM Members