Home Forums SQL Server 2005 T-SQL (SS2K5) Calculating age RE: Calculating age
ELSSON
SSC Rookie
Points: 32
More actions
May 4, 2017 at 2:46 pm
#1941162
Is most simple: DECLARE @Birthday date = '1994/12/10'
SELECT (CAST(CONVERT(VARCHAR(8), GETDATE(), 112) AS INT) - CAST(CONVERT(VARCHAR(8), @Birthday, 112) AS INT)) / 10000 AS Age