--function to compute age given date of birth CREATE FUNCTION fnGetAge (@d datetime) RETURNS INT AS BEGIN DECLARE @age INT SET @age = ( CASE WHEN DATEADD(YEAR, DATEDIFF (YEAR, @d, CURRENT_TIMESTAMP), @d) > CURRENT_TIMESTAMP THEN DATEDIFF(YEAR, @d, CURRENT_TIMESTAMP) - 1 ELSE DATEDIFF(YEAR, @d, CURRENT_TIMESTAMP) END) RETURN @age END GO --create table for testing CREATE TABLE #tem (birthdate DATETIME) go --insert some dummy values INSERT INTO #tem VALUES ('1981-01-09') INSERT INTO #tem VALUES ('1981-01-10') INSERT INTO #tem VALUES ('1981-01-11') INSERT INTO #tem VALUES ('2000-01-01') INSERT INTO #tem VALUES ('2012-01-01') GO --test our function SELECT birthdate, dbo.fnGetAge(birthdate) FROM #tem GO
Computer, Technology, Databases, Google, Internet, Mobile, Linux, Microsoft, Open Source, Security, Social Media, Web Development, Business, Finance
Wednesday, January 11, 2012
Determine age given date of birth using SQL
The following Microsoft SQL function will help return an integer, determining one's age given date of birth. Hope it helps.
Subscribe to:
Post Comments (Atom)
-
Google url shortener service, goo.gl , is now much improved with newly included features like easier copy and paste, and ability to delete e...
-
According to an article from the MSDN , DirectoryInfo.GetFiles() method will give unexpected behaviour on 3-letter extensions. I quote Micr...
-
Installed FortiClient recently but the challenge in disabling the application/service from running automatically on every start-up annoyed m...
-
ActiveSG is a national initiative from the Singapore government to encourage all to stay healthy and keeping fit. Membership registration i...
No comments:
Post a Comment
Do provide your constructive comment. I appreciate that.