The page you linked is actually to Postregsql, an open-source database, and the functions listed are not available in Microsoft SQL.  If you're relatively inexperienced in SQL, I urge you to TEST THIS FIRST and, if at all possible, have a DBA help you to get it in place.

Grab the code from the marked solution on the following page starting with 'CREATE FUNCTION' and ending with the last 'END'. . .:

http://social.msdn.microsoft.com/forums/en-US/tran...

Change the line reading:

RETURN CAST(@YEAR AS VARCHAR) + 'Y:' + RIGHT('00'+CAST(@Month AS VARCHAR),2) + 'M:'+ RIGHT('00'+CAST(@Day AS VARCHAR),2) + 'D'

to

 RETURN
    CASE
        WHEN @YEAR = 1
        THEN CAST(@YEAR AS VARCHAR) + ' Year, '
        WHEN @YEAR > 1
        THEN CAST(@YEAR AS VARCHAR) + ' Years, '
        ELSE ''
    END +
    CASE
        WHEN @MONTH = 1
        THEN CAST(@MONTH AS VARCHAR) + ' Month, '
        WHEN @MONTH > 1
        THEN CAST(@MONTH AS VARCHAR) + ' Months, '
        ELSE ''
    END +
    CASE
        WHEN @DAY = 1
        THEN CAST(@DAY AS VARCHAR) + ' Day'
        WHEN @DAY > 1
        THEN CAST(@DAY AS VARCHAR) + ' Days'
        ELSE '0 Days'
    END

Once you've loaded the function into your SQL database, your query will now look like:

I hope this helps!