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.