将存储的日期和时间转换为用户友好的输出

Question

So I am storing messages in a SQL table with type: timestamp default: CURRENT_TIMESTAMP which looks like this: 2014-11-11 11:43:23 in the database and when printed.

I am printing the time along with the messages, but am looking for a way to convert this to a more user-friendly format, i.e. something that is dynamic and says, "12:15" if it was written today or something like "Monday 12:15" if it were written on monday at 12:15.

As I have never done anything like this, I am wondering if there are snippets that handle this (I couldn't find any for my stored format), or will I need to start from scratch?

I am certainly open to storing the time differently if someone knows of a program for a specific stored format.

Anyway, Sincere thanks for any help. It is greatly appreciated.

Answer 1

You can use Carbon library, its an extension of PHP's DateTime class. It has what you're looking for: https://github.com/briannesbitt/Carbon#api-humandiff

It will show relative time like "an hour ago" or "10 days ago", etc.