Unix timestamp to days, hours, minutes

Question

So, I have a field in my users table named last_active which updates every time a user reloads a page.
It's stored in unix timestamp.

I would like to output it like this: Last online: 4 d 18 h 19 m ago

How would one do that? Can you do it with php's date()?

Thank you.

Answer 1

The simplest approach to this is to take the last_active timestamp, and the current timestamp with time(). Then subtract the last active from the current timestamp, and then you simply divide the result with the amount of seconds in a day to get difference in days, amount of seconds in an hour to get difference in hours and so on.

This approach may be slightly inaccurate in some special cases (leap years, etc.) but it should suffice for your simpler usecase

Answer 2

You could achieve this directly in MySQL if you like:

select date_format(from_unixtime(current_timestamp - last_timestamp), 
    'Last online: %e days, %k hours, %i minutes, %s seconds ago.');

(current_timestamp can be replaced with unix_timestamp(now()) if you want it calculated in-place)

DATE_FORMAT allows you to have a custom string based on a specific date. If you populate its date with the difference between two timestamps, it will work as you've asked.

The above solution will only work if it's under a month; if you want days of the year, use %j. The documentation for the function shows more.

Answer 3

Check out this article, it's exactly what you need

http://blog.fedecarg.com/2009/06/25/format-a-time-interval-with-the-requested-granularity/