[RESOLVED] Convert and compare time to DB timestamp

Pikachu2000

I have a timestamp in my DB (in the '2010-02-16 23:27:15' format) I need to compare to the current time, and set a variable based on whether at least a week has passed since the DB record was inserted. Something like this:

get the stamp from the DB
if( record was inserted less than 7 days ago ) {
     $expired = false;
} else {
$expired = true;
}

In an attempt to pull the DB timestamp and convert it to a UNIX time to do the comparison, I've tried several combinations of date(), time(), and mktime() with no success. What function(s) should I use to get this done?

laserlight

You can try [man]strtotime/man.

bradgrafelman

Sounds like you should just do it in SQL to make it easier:

SELECT IF(DATE_ADD(date_col, 1 WEEK) < NOW(), 1, 0) AS weekHasPassed ..

Pikachu2000

Laserlight and Brad,

I'll see what I can figure out with those and let you know how it goes . . . Thank you!

Pikachu2000

OK, now that I've had time to look at this, with the help from you guys and the MySQL manual, I got it working as desired with:

SELECT IF(DATE_ADD(date_time, INTERVAL 1 WEEK) < NOW(), 1, 0) AS expired FROM . . .

Thanks again for the assistance!