Laravel RAW query with IGNORE doesn't work as expected

are you changing FLIGHT column or DEPARTURE column.. as it stands it looks like your table is called departure and column flight which doesnt make sense to me.

sorry for my bad choice of words. I've updated table and column name for better clarity

no worries.. what happens if you actually hard code the date instead of using the ? syntax.

DB::update(UPDATE IGNORE schedule SET departure_date = "2019-00-00" WHERE id = "13"');

like this? still same weird result, 0000-00-00

can you post your column info (Ie how you are storing this in your db, ie show create statemnt)

I create my table using Migration

Schema::create('schedule', function (Blueprint $table) {
    $table->increments('id');
    $table->date('departure_date')->nullable();
});

for creating new record I replace the 00 in date to 01, store it using Eloquent, then update the newly created record with actual incomplete date.

use Illuminate\Http\Request;
use App\Schedule; // model for table 'schedule'
...
public function update(Request $request)
{
    // validation here
    ....    
    $actualDate = $request->departure_date;
    ....
    // modifying the date then assign it to '$request'
    $request->departure_date = $modifiedDate;
    ....
    $schedule= new Schedule($request);
    $schedule->save();

    DB::update('UPDATE IGNORE schedule SET departure_date = ? WHERE id = ?', [$actualDate, $schedule->id]);
    // result: '0000-00-00'
}

I separate it because I want other column to be inserted in strict mode.