using datediff function in sql

select datediff(year,'Nov 30 2001',getdate()) as diffyear 

select datediff(month,'Nov 30 2001',getdate())as diffmonth

 select datediff(day,'Nov 30 2001',getdate()) as diffdaydiffyear

 diffyear

-----------

 7 (1 row(s) affected)

diffmonth

-----------

78(1 row(s) affected)

diffday

----------

2357(1 row(s) affected)