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
date difference
Moderator: General Moderators
- EverLearning
- Forum Contributor
- Posts: 282
- Joined: Sat Feb 23, 2008 3:49 am
- Location: Niš, Serbia
Re: date difference
I guess you're talking about MySql based on the date format. Use
For more information look up MySql Date and Time Functions
Code: Select all
SELECT DATE_ADD('2008-07-28 23:59:59', INTERVAL 7 DAY);