Query builder not inserting timestamps Query builder not inserting timestamps laravel laravel

Query builder not inserting timestamps


All right. Fields created_at,update_at and deleted_at are "part" of Eloquent. You use Query Builder=> inserting doesn't affect on these two fields (created_at and updated_at). You should define it manually like:

$id = DB::table('widgets')        ->insertGetId(array(            'creator' => Auth::user()->id,            'widget_name' => $request->input('widget_name'),            'pages' => json_encode($request->input('pages')),            'domain' => $request->input('domain'),            "settings" => $settings,            "created_at" =>  \Carbon\Carbon::now(), # new \Datetime()            "updated_at" => \Carbon\Carbon::now(),  # new \Datetime()        ));


In my case, I'm using date('Y-m-d H:i:s'); to get current dateTime. It works every time.

    $id = DB::table('widgets')        ->insertGetId(array(            'creator' => Auth::user()->id,            'widget_name' => $request->input('widget_name'),            'pages' => json_encode($request->input('pages')),            'domain' => $request->input('domain'),            "settings" => $settings,            "created_at" =>  date('Y-m-d H:i:s'),            "updated_at" => date('Y-m-d H:i:s'),        ));