rho_pooka (1/10/2014)

---

Greetings, another question for the group. I've been writing out my own homework exercises as I work through the 461 training kit; one of the problems I posed for myself was the following:

Find difference in years, then months, then days between youngest employee and oldest employee… create column name “Age Gap”, value should be read: “diff in (years), diff in (months), diff in (days)”

So here is the code I wrote out, then my question at the bottom

DECLARE @youngest AS DATE

DECLARE @oldestAS DATE

SET @youngest =

(SELECT TOP (1) birthdate FROM hr.employees

ORDER BY birthdate DESC)

SET @oldest =

(SELECT TOP (1) birthdate FROM hr.employees

ORDER BY birthdate ASC)

SELECT CONCAT('The diff in years ', (DATEDIFF(month, @oldest, @youngest))) AS

'Age Gap'

My question is first, is there an easier way of doing this, secondly how come when I add another variable "@interval" and add it to the DATEDIFF statement it does not work?

DECLARE @youngest AS DATE

DECLARE @oldestAS DATE

DECLARE @interval AS VARCHAR (10)

SET @interval = 'month'

SET @youngest =

(SELECT TOP (1) birthdate FROM hr.employees

ORDER BY birthdate DESC)

SET @oldest =

(SELECT TOP (1) birthdate FROM hr.employees

ORDER BY birthdate ASC)

SELECT CONCAT('The diff in ', @interval, ' ', (DATEDIFF(@interval, @oldest, @youngest))) AS

'Age Gap'