If DATE > 60....

[Studentjobs]

Hello,
I have a site that allows people to post job listings. To save bandwith, they only run for 60 days. The job listings are stored in a MySQL Database, with a date stamp. I want to be able to know how many days ago the job was posted. That way, if it was posted over 60 days ago then it would print "Job Listing Expired." Thanks for your help in advance.

-Mike

[tomhath]

The easy way to find the difference between two datetime values is to convert them to a UNIX Timestamp and take the difference between them. There are examples in the Code Snippet library on this site. But all you need is to use mktime() to get the timestamp (number of seconds since Jan 1, 1970).

There are 86400 seconds in a day (246060), check if the difference between the two timestamps is more than 86400 * the number of days.

This calculation is a one liner that should become a "design pattern" you recognize and code without a second thought (pun intended).

[mmilano]

if you are using mysql and a date or timestamp field, then you can simply query only for jobs before 60 days ago without having to use unixtime:

SELECT * from listings where listing_date > DATE_SUB(now(), INTERVAL 60 DAY);

this may be helpful to you also: http://www.mysql.com/doc/en/Date_and_time_functions.html