Insert null in date field in postgresql using collection

Question

I am trying to insert an array with date field - end_date in postgresql with Laravel 5.7. But this gives an error -

SQLSTATE[23502]: Not null violation: 7 ERROR:  null value in column \"end_date\" violates not-null constraint

I am using Laravel 5.7, Postgresql 9.3

$array = [
  "amazon_store_id" => 4
  "advertising_profile_id" => 1
  "campaign_id" => 123
  "name" => "6 shelf 2"
  "campaign_type" => "sponsoredProducts"
  "targeting_type" => "manual"
  "premium_bid_adjustment" => true
  "daily_budget" => 15.0
  "start_date" => "2014-11-25 09:32:18"
  "end_date" => null
  "state" => "paused"
  "serving_status" => "CAMPAIGN_PAUSED"
  "creation_date" => "2014-11-07 10:17:03"
  "last_updated_date" => "2018-10-24 12:49:54"
  "created_at" => "2018-12-24 09:32:18"
  "updated_at" => "2018-12-24 09:32:18"
];
DB::table($table_name)->insert($array->toArray());

Ideally it shall insert the null in the database.

Udhav Sarvaiya · Accepted Answer · 2018-12-25 15:14:16Z

1

In your migration you can do this to make the column nullable:

public function up()
{
    Schema::create('tablename', function (Blueprint $table) {
        $table->dateTime('end_date')->nullable();
    });
}

->nullable() Designate that the column allows NULL values

answered Dec 25, 2018 at 15:14

Udhav Sarvaiya

10.2k13 gold badges60 silver badges68 bronze badges

Sign up to request clarification or add additional context in comments.

Comments

common sense · Accepted Answer · 2018-12-24 17:57:02Z

0

In your migration file you have to define the date field as nullable.

Schema::table($table_name, function (Blueprint $table) {
    $table->dateTime('end_date')->nullable();
});

answered Dec 24, 2018 at 17:57

common sense

3,9106 gold badges26 silver badges35 bronze badges

Collectives™ on Stack Overflow

Insert null in date field in postgresql using collection

2 Answers 2

Comments

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

Comments

Comments

Your Answer

Sign up or log in

Post as a guest

Related