php - 无法在 MySQL-PHP 中的数据库列日期时间类型中存储值

Question

我想在具有 dattime 类型的数据库列中保存和存储 $​​interval 的日期格式。但它不起作用，在数据库中不显示该值。

 if ($no > 1){
     $startdate = new DateTime($lup[$no]);
     $enddate = new DateTime($lup[$no-1]);
     $int = $startdate->diff($enddate);
     $interval = $int->format("%d days, %h hours, %i minutes, and %s seconds  ");
     echo "<td>".$interval."&nbsp;</td>";
    }else
    {
     echo "<td> --- </td>&nbsp;";
    }

 if ($data['id'] == 2){
  $sql = mysql_query("
  INSERT INTO sla (booking_id, approval)
  VALUES ('$booking_id[$no]', '$interval')")
 ;}

Answer 1

试试这个:

if ($no > 1){
    $startdate = new DateTime($lup[$no]);
    $enddate = new DateTime($lup[$no-1]);
    $int = $startdate->diff($enddate);
    $interval = $int->format("%d days, %h hours, %i minutes, and %s seconds  ");
    $dtInterval = $int->format('Y-m-d H:i:s');
    echo "<td>".$interval."&nbsp;</td>";
   }else
   {
    echo "<td> --- </td>&nbsp;";
   }

if ($data['id'] == 2){
 $sql = mysql_query("
 INSERT INTO sla (booking_id, approval)
 VALUES ('$booking_id[$no]', '$dtInterval')")
;}