SQL Server - DATE DIFF (UNA PEQUEÑA TAREA)

select

DATEDIFF(YEAR,10-25-2004, getdate())as 'Años',

DATEDIFF(MONTH,10-25-2004,getdate())as 'meses',

DATEDIFF(day,10-25-2004,getdate())as 'dias';

Declare @dateofbirth datetime

Declare @years varchar (40)

Declare @months varchar (30)

Declare @days varchar (30)

set @dateofbirth='10-25-2004'-- Fecha de nacimiento

select @years=datediff(year,@dateofbirth,getdate())-- Busca los años

select @months = (datediff(year,@dateofbirth,getdate())*12) - datediff(month,@dateofbirth,getdate()) -- Busca los meses

-- To Find Months

select @days=datepart(d,@dateofbirth) - datepart(d,getdate()) -- Busca los dias

select @years  +' Años,   ' +@months +' Meses,   '+@days   +' dias' as 'Años-Meses-Dias'