using datediff function in sql

Posted on May 14, 2008. Filed under: Sql Server |

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)

Make A Comment: ( None so far )