Forum

How to store empty DateTime input to Null value instead of 0000:00:00 00:00 valu...

Hi, i had two input Datetime field. User can choose to fill in either these two field. For the empty input Datetime field, i want it to store as Null value in Database. But currently the empty input Datetime field is store as 0000:00:00 00:00 value in Database. What code should i modified?

icodejc
icodejc
  • 2 weeks ago

set the column default value to NULL in your database db structure

or in your migration script

$table->timestamp('start_date')->nullable();

Change you migration script according below given:

$table->timestamp('start_date')->nullable()->default(null);

Hope this work for you.