Question

I have a typical function in model which is receiving time from table Orders :

public function get_time() {
    $result = array();
    $result = DB::select( id ,  time ,  description )->from( orders )->execute();
    return $result;
}

问题是,时间领域以格式储存在MySQL中:,例如:11:45:00。

But I don t need seconds, so I can do: date( H:i , strtotime($time)); Doing this in a View isn t good idea. I need to do this conversion in Model or Controller. Of course:

$result[ time ] = date( H:i , strtotime(result[ time ]));

a. 获得工作;

Answer 1

Doing it in the view is perfect, it s formatting the model result to be displayed correctly.

$result[ time ] = date( H:i , strtotime(result[ time ]));

有一种同义的错误,你认为必须预先确定<代码>result,并注明美元值。

zombor说的话也很重要(我错过了)

成果是数据库成果处理器物体,而不是单一结果

Answer 2

• 检查技术、工程和技术部的职能:

SELECT TIME_FORMAT( 11:45:00 ,  %H:%i )

结果11:45。修改法典如下:

$result = DB::select( id , array( TIME_FORMAT("time",  %H:%i ) ,  formatted_time ),  description )->from( orders )->execute();

友情链接