douwen3127 2015-09-05 20:40
浏览 42
已采纳

将代码点火器的mysql时间戳转换为实际时间mm dd yyyy hh mm [复制]

This question already has an answer here:

Im trying to get the mysql timestamp to go to actual time. The PHP code im using though code igniter echos out the pub date for news articles but, its in this format yyyy-mm-dd hh:mm:ss I want it in MM/DD/YY HH:MM the code echos it out after running a query from a controller here is the code from the view <?php echo $row->pubdate; ?> pubdate is the column name from the MYSQL database. I've looked around stack overflow for an answer to this but I have not been able to find anything that works for my situation.

</div>
  • 写回答

1条回答 默认 最新

  • dqm83011 2015-09-05 20:44
    关注

    You could create a function which takes a MySQL formatted date and returns the format you want, something like this:

    function nice_date($mysql_date)
    {
        list($date,$time) = explode(" ",$mysql_date);
        list($year,$month,$day) = explode("-",$date);
        return $month.'/'.$day.'/'.$year.' '.$time;
    }
    

    Use explode to split the given date into $date and $time variables (using list to assign the variables), then split $date into year, month and day. Then simply return a string with the variables reordered.

    本回答被题主选为最佳回答 , 对您是否有帮助呢?
    评论

报告相同问题?

悬赏问题

  • ¥15 【Hadoop 问题】Hadoop编译所遇问题hadoop-common: make failed with error code 2
  • ¥15 vb6.0+webbrowser无法加载某个网页求解
  • ¥15 RPA财务机器人采购付款流程
  • ¥15 计算机图形多边形及三次样条曲线绘制
  • ¥15 根据protues画的图用keil写程序
  • ¥200 如何使用postGis实现最短领规划?
  • ¥15 pyinstaller打包错误
  • ¥20 cesm的气溶胶排放文件
  • ¥15 逐月累计,月份不连续,补齐月份
  • ¥15 应用简单的Python代码完成一个学生成绩管理系统