--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)
-
Installed FortiClient recently but the challenge in disabling the application/service from running automatically on every start-up annoyed m...
-
If you have been reading the mainstream media or the social media, it is likely that you would have heard of SimplyGo - an initiative by the...
-
Gartner Report on the Magic Quadrant for Digital Experience Platforms as published on 26 Jan 2021.
-
As of today, Google will start using a new shortened url - g.co , to promote Google websites. g.co works differently as compared to a long-t...
No comments:
Post a Comment
Do provide your constructive comment. I appreciate that.