tp5查询时将时间戳直接转为年月日类型

写法   FROM_UNIXTIME(daytime,"%H:%i) as daytime

示例如下:

/************设备流量图*********************/
public function device_flow_map(){
$deviceId=$this->request->param('deviceId');
$date=$this->request->param('date','today');
$one=Db::name('device_lists')->where('deviceId',$deviceId)->field('id,deviceId,description,deviceIconType,statusEnum')->find();
if(!$one){
$this->error('该设备不存在');
}
$arr['upload_list']=Db::name('device_band')->where('deviceId',$deviceId)->whereTime('daytime',$date)->where('type','upload')->field('id,deviceId,bandWidth,FROM_UNIXTIME(daytime,"%H:%i") as daytime')->select();
$arr['download_list']=Db::name('device_band')->where('deviceId',$deviceId)->whereTime('daytime',$date)->where('type','download')->field('id,deviceId,bandWidth,FROM_UNIXTIME(daytime,"%H:%i") as daytime')->select();
$this->success('成功',$arr);

}

这里把 daytime格式化了,只保留小时和分钟部分

THE END