MySQL date difference

Question

I use MySQL and PHP, and I want to find the difference between the two dates.

I have a table with a name advertisersthat has a field web_start_date. I want to select all entries where web_start_dateless than 30 days from the current date

Answer 1

Just use the datediff function of MySQL.

Answer 2

use the DATEDIFF () function mysql

Answer 3

WHERE web_start_date < TIMESTAMPADD(DAY, 30, NOW())

Answer 4

hmmm .. try this, see if this works for you :)

SELECT * FROM advertisers WHERE DATE(web_start_date) > DATE_SUB(NOW(), INTERVAL 30 DAY)