du_1993 2014-11-19 06:14
浏览 31
已采纳

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

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.

  • 写回答

5条回答 默认 最新

  • duanjia4220 2014-11-19 06:22
    关注

    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.

    本回答被题主选为最佳回答 , 对您是否有帮助呢?
    评论
查看更多回答(4条)

报告相同问题?

悬赏问题

  • ¥20 access多表提取相同字段数据并合并
  • ¥20 基于MSP430f5529的MPU6050驱动,求出欧拉角
  • ¥20 Java-Oj-桌布的计算
  • ¥15 powerbuilder中的datawindow数据整合到新的DataWindow
  • ¥20 有人知道这种图怎么画吗?
  • ¥15 pyqt6如何引用qrc文件加载里面的的资源
  • ¥15 安卓JNI项目使用lua上的问题
  • ¥20 RL+GNN解决人员排班问题时梯度消失
  • ¥60 要数控稳压电源测试数据
  • ¥15 能帮我写下这个编程吗