select datediff (d,'2009-05-19',Datename(year,GetDate())+'-'+Datename(month,GetDate())+'-'+Datename(day,GetDate()))Select Datename(year,GetDate())+'-'+Datename(month,GetDate())+'-'+Datename(day,GetDate())