Viewing 2 posts - 1 through 2 (of 2 total)
May 5, 2017 at 10:13 am
#1941342
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
May 4, 2017 at 2:46 pm
#1941162