find if date is older than 30 days

Question

The date string looks like this

2011-08-19 17:14:40

(year-month-day hours:minutes:seconds)

How can I find out if the date is older than the current date with more than 30 days?

Answer 1

Try using something like this:

 if(strtotime('2011-08-19 17:14:40') < strtotime('-30 days')) {      // this is true  } 

Besides, this string looks like it is stored in SQL as datetime/timestamp field. You can directly select all entries from your database with old dates using:

SELECT ... WHERE `datetime` + INTERVAL 30 DAY < NOW() 

Answer 2

If you are on PHP 5.3 or higher you can do:

$someDate = new \DateTime('2011-08-19 17:14:40'); $now = new \DateTime();  if($someDate->diff($now)->days > 30) {    echo 'The date was more than 30 days ago.'; }