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.
views:
61answers:
1
+5
A:
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 by 60*60*24
to get it in days
It's also doable using DateTime::diff, although I find the date functions easier than using the classes
Michael Mrozek
2010-06-22 03:27:14