Home
> SQL Script > Calculating Age
Calculating Age
CASE
WHEN Month(GetDate()) < Month(c.[BirthDate])
THEN DateDiff(yy,c.[BirthDate],GetDate()) – 1
WHEN Month(GetDate()) = Month(c.[BirthDate])
AND Day(GetDate()) < Day(c.[BirthDate])
THEN DateDiff(yy,c.[BirthDate],GetDate()) – 1
ELSE DateDiff(yy,c.[BirthDate],GetDate())
END AS [Age]
WHEN Month(GetDate()) < Month(c.[BirthDate])
THEN DateDiff(yy,c.[BirthDate],GetDate()) – 1
WHEN Month(GetDate()) = Month(c.[BirthDate])
AND Day(GetDate()) < Day(c.[BirthDate])
THEN DateDiff(yy,c.[BirthDate],GetDate()) – 1
ELSE DateDiff(yy,c.[BirthDate],GetDate())
END AS [Age]
Categories: SQL Script
Comments (0)
Trackbacks (0)
Leave a comment
Trackback