laravel-5 - 检索时创建于时间戳为空

Question

我正在使用传感器保存数据，其中数据是这样来的

$input = $request["date"].' '.$request["time"]; 

        $newDate= DateTime::createFromFormat('d/m/Y H:i:s',$input);     
$created_date = $newDate->format('Y-m-d H:i:s'); // for example
    try{

           $SensorData = SensorData::create([
            'sensor_id' => $request['sensor']['id'],            
            'created_at' => "".$created_date."",


        ]);

$sensor_data=SensorData::join('sensors','sensors.id','=','sensor_id')->orderBy('sensor_data.created_at','DESC')->get();

它在数据库中保存日期时间，2020-05-04 01:10:12但是当检索值时它显示null

标签： laravel-5eloquent

Answer 1

usingDB子句解决了问题

$sensor_data = DB::table('sensors')
            ->join('sensor_data', 'sensors.id', '=', 'sensor_data.sensor_id')
            ->get();