Monday, June 10, 2013

How To Select Days,Months, Years Between two dates

select DATEDIFF(dd,getdate(),'2013-04-15')
Result : -56

select DATEDIFF(mm,getdate(),'2013-04-15')
Result : -2

select DATEDIFF(yy,getdate(),'2013-04-15')
Result : 0

No comments :

Post a Comment