Calculating a timestamp

[jim.davidson]

I have a timestamp field in my mySQL table and need to check if it's 14 day or older.  What's the best way to do this?

 

Any help will be appreciated

[The Eagle]

Although I don't completely understand I've a brief idea of what you want to accomplish.

 

$time = strtotime('$time');
$two_weeks_ago = strtotime('-2 week');

if( $time > $two_weeks_ago ) { 
echo "";
} else {
echo "";
}

[AbraCadaver]

Depends on what you mean by "check".  Do you want to select records that are 14 days or older or not select records that are 14 days or older?  This will do those:

 

Older than 14 days:

SELECT * FROM table_name WHERE (  TO_DAYS(CURDATE()) - TO_DAYS(column_name)  ) > 14

 

Not older than 14 days:

SELECT * FROM table_name WHERE (  TO_DAYS(CURDATE()) - TO_DAYS(column_name)  ) <= 14

[jim.davidson]

Thank you, now that I see it it seems simple enough even for me.  Again Thanks