Skip to main content

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.

--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

Popular Posts

How to stop FortiClient from starting automatically?

Installed FortiClient recently but the challenge in disabling the application/service from running automatically on every start-up annoyed me. Attempt to stop 'FortiClient Service Scheduler' only return 'Parameter is incorrect' error message.

An article on Technet help solve my trouble. To stop FortiClient from starting automatically, try the following:
Shut down FortiClient from the system tray.
Run net stop fortishield on command prompt.
Run msconfig.
On msconfig, switch to the Services tab. Clear the FortiClient Service Scheduler check box and click Apply.Run services.msc on command prompt to open up show all available services.Look for FortiClient Service Scheduler. Switch Startup type to Manual.Restart your computer. FortiClient should not be running automatically the next time round. Hope it helps.

Ho Ching named 5th most powerful and is mistaken as first lady by Forbes

Forbes named Singapore Prime Minister wife and CEO of Temasek Holdings, Ho Ching, as the 5th most powerful woman in the world. Ho Ching is mistaken as Singapore's first lady! OMG!

I wonder how can Forbes makes such a blunder. For a complete list, refer to here.

Speech by Mr Inderjit Singh on Population White Paper

People's Action Party MP, Mr Inderjit Singh, debated on the Population White Paper and put up his point across that he is against his own party's 6.9m projected population. I applaud his courage to stand up against the party whip and for his fellow Singaporeans.

His key points are;

Slow down immigration and focus on resolving all issue related to the past population boom.We can live with a slightly slower growth (not zero or slow growth) and hence moderate dependence on foreigners.Use the Dubai model to complement our local workforce with foreign workforce, but don’t grant them PRs – ie a transient workforce.Abandon the 6.9m figure by 2030, this will be another rapid growth which we cannot handle.Solve Singaporeans problems first and also don’t give PRs same privileges as citizens.
As published on Mr Inderjit Singh's Facebook status, the full speech made in the parliament is as below:

Speech by Mr Inderjit Singh, MP for Ang Mo Kio GRC
On the White Paper on Population


Madam S…