This question already has answers here:
Convert to date format dd/mm/yyyy
(6个答案)
5年前关闭。
            In mysql data base the date is f=stored in the format of now() function like yyyy mm dd hh mm ss. But in frontend tool i want it like dd mm yyyy hh mm ss how can i convert it.


<?php
 $addqry=mysql_query("INSERT INTO `exam`    (`user_id`,`sub_id`,`q_id`,`stud_ans`,`date_time`)VALUES ('$user', '$sub', '$ans', '$stud_ans',(Now()))");
    $stud_ans=' ';
            if($addqry)
            {
            //result
            $date;
            $last_date=mysql_query("SELECT date_time FROM exam ORDER BY id DESC LIMIT 1; ");
            while($res_last=mysql_fetch_array($last_date))
            {
            $date=$res_last['date_time'];
            }
            ?>

这里给出的日期时间格式是2014-04-12 15:34:40,但我希望是2014-04-12 15:34:40

最佳答案

尝试

$date=date('d-m-Y H:i:s', strtotime($res_last['date_time']));

更多信息:-http://php.net/manual/en/function.date.php

关于php - 怎么把yyyy mm dd h:m:s转换成dd mm yyyy h:m:s? ,我们在Stack Overflow上找到一个类似的问题:https://stackoverflow.com/questions/23053938/

10-12 00:06
查看更多