Home Forums Article Discussions Article Discussions by Author Discuss content posted by Jesse McLain Best Way to Calculate Age RE: Best Way to Calculate Age
andre.deslauriers
SSC Veteran
Points: 278
More actions
March 6, 2008 at 7:37 am
#785972
That one works flawlessly.
DECLARE @DateOfBirth VARCHAR(10)
SET @DateOfBirth = '1960-03-07'
print YEAR(GETDATE()) - YEAR(@DateOfBirth) - CASE WHEN MONTH(GETDATE())*31 + DAY(GETDATE()) >= MONTH(@DateOfBirth)*31 + DAY(@DateOfBirth) THEN 0 ELSE 1 END