I am using MySQL and PHP, and I want to find the difference between two dates.
I have a table named advertisers, which has a field web_start_date. I want to select all entries where the web_start_date is less than 30 days from the current date
views:
36answers:
4+1 There's no need for adding or subtracting when there's a function designed for the job: `SELECT * FROM advertisers WHERE DATEDIFF(NOW(), web_start_date) < 30;`
Mike
2010-07-08 14:21:47
...or swap the values round if you are comparing now with future dates: `SELECT * FROM advertisers WHERE DATEDIFF(web_start_date, NOW()) < 30;`
Mike
2010-07-08 15:18:40
A:
hmmm.. try this, see if it work for you :)
SELECT * FROM advertisers WHERE DATE(web_start_date) > DATE_SUB(NOW(), INTERVAL 30 DAY)
Puaka
2010-07-08 14:08:06