duan5801 2012-06-18 21:17
浏览 85
已采纳

在PHP中,如何格式化从数据库收集的日期?

I have been trying to use date_format, however as far as I know, it only takes timestamps and then it formats the date in whatever way you want to display it.

My issue is the following, the dates in my database are with the following format:

 2012-05-14 // (Y-m-d)

and I want to display them as: June 14th, 2012 or the closest format to that.

Is there any built-in date in PHP to make such transformation? Thanks!

  • 写回答

6条回答 默认 最新

  • duan0427 2012-06-18 21:21
    关注

    Do the transformation in the database, so you don't do multiple round-trips through various string/binary formats each time:

    SELECT DATE_FORMAT(yourdatefield, '%M %D, %Y')
    

    relevant docs here: http://dev.mysql.com/doc/refman/5.5/en/date-and-time-functions.html#function_date-format

    Anything else will require the following transformations sequence:

    mysql native -> mysql string -> php string -> php timestamp -> php string
    v.s.
    mysql native -> mysql string -> php string
    
    本回答被题主选为最佳回答 , 对您是否有帮助呢?
    评论
查看更多回答(5条)

报告相同问题?

悬赏问题

  • ¥15 用ucinet怎么计算子群体个数和核心边缘结构拟合度
  • ¥15 nrf52810-c三个a 程序
  • ¥15 lego-loam跑出来的roll误差很大
  • ¥50 求一个半透明没有锯齿的圆角窗体的实现例子
  • ¥15 STM32cubeMX里的FreeRTOS无法释放内存
  • ¥15 CATIA有些零件打开直接单机确定终止
  • ¥15 请问有会的吗,用MATLAB做
  • ¥15 phython如何实现以下功能?查找同一用户名的消费金额合并—
  • ¥15 孟德尔随机化怎样画共定位分析图
  • ¥18 模拟电路问题解答有偿速度