Possible Duplicate:
How to calculate the difference between two dates using PHP?
I have timestamps stored in the format YYYY-MM-DD HH:MM:SS
(for example 2010-06-21 20:12:56
). What would the best way to check how old the timestamp is? For the moment I am mainly interested in the number of days old.
You can use
strtotime
to convert the string to a UNIX timestamp, which is in seconds.time()
will give you the current UNIX timestamp. Subtract them to get how old the date is in seconds, and divide by60*60*24
to get it in daysIt's also doable using DateTime::diff, although I find the date functions easier than using the classes