Unable ton insert date on Database

In your database make sure you have a date field.

This is the case ^^

can you show your code where the insert is taking place, and are other fields being inserted ok.
Edit: saw this https://laracasts.com/discuss/channels/laravel/how-to-format-a-carbon-date-inside-blade
So read this and see if it's a formatting issue.

Here is my code and yes, when I fill an other field, it's inserted well on the DB :

    public function update(Request $request, $userId)
    {
        $user = User::findOrFail($userId);
        if ($user){
            if (Auth::check() && $user == Auth::user()){
            $this->validate($request, [
                'nickname'      => "required|unique:users,nickname,{$user->id}|min:2",
                'last_name'     => 'min:2',
                'first_name'    => 'min:2',
                'email'         => 'required|email',
                'date_of_birth' => 'date_format:d/m/Y',
                'country'       => 'min:2',
                'city'          => 'min:2',
                'avatar'        => 'image',
            ]);
            //Format the date for the database
            $request->date_of_birth = Carbon::createFromFormat('d/m/Y', $request->date_of_birth)->format('Y-m-d');


            // User update
            $user->update($request->only('nickname', 'email', 'last_name', 'first_name', 'gender', 'date_of_birth', 'country', 'city', 'games', 'avatar'));
            return back()->with('success', "Votre profile a bien été modifié !");
            }else{
                return back()->with('error', "Vous n'êtes pas autorisé à modifier ce profile !");
            }
        }else{
            return redirect('/')->with('error', 'Profile inexisant');
        }
    }

I can't see a solution on your link because to format the date, we need to create here before, like I already do on my controller

Did you see my edit, look over the other post.

I've already saw your other post and and I answer your on editing my question, but I give it to you back :

I can't see a solution on your link because to format the date, we need to create here before, like I already do on my controller

Try testing without carbon

date_format($request->date_of_birth, 'Y-m-d');

If that works, then there is a formatting issue with carbon.

It will return an error because the first parameter is not a DateTime, it's just a string from the field

See this stackoverflow post, it should have the answer. http://stackoverflow.com/questions/33405939/laravel-5-carbon-format-datetime

You cannot do this:

$request->date_of_birth = Carbon::createFromFormat('d/m/Y', $request->date_of_birth)->format('Y-m-d');

There is no magic setter methods in the Request class. Try using the replace method instead.

$request->replace(['date_of_birth' => Carbon::createFromFormat('d/m/Y', $request->date_of_birth)->format('Y-m-d')]);

@thomaskim Okay, I thought that I could do this but okay, thanks for your help :)

@jlrdw thkans for your help too :)

@thomaskim Whoops, I come back to say that it replace all my requests parameters and it keep only the date. How I can solve it ? Because I want other parameters too ^^

@ARAGORND7 Sorry about that. :) Use the merge method instead of replace then.

$request->merge(['date_of_birth' => Carbon::createFromFormat('d/m/Y', $request->date_of_birth)->format('Y-m-d')]);

Thanks for this help :)