time difference problem

Hi all

I want to calculate date difference between two times, i have a time like ('2008-07-28 23:59:59') and then interval in days like 7 days

I want to add time + interval in days and then want to find difference with the current time.


any idea....

thank you
dizyn

 

Select Datediff('2008-07-22 23:59:59'+ Interval 7 Day, Curdate());