Laravel put null in created_at and updated_at while inserting new record

Question

I don't know why, but when I want to insert something:

users::insert([
    'first_name' => $first_name,
    'last_name' => $last_name,
    'remember_token' => $remember_token,
]);

It just inserts NULL into created_at and updated_at columns. I have tried these:

'create_at' => time(),
'updated_at' => time(),

'create_at' => '',
'updated_at' => '',

'create_at' => TRUE,
'updated_at' => TRUE,

But none of them worked, but just TRUE put 0000-00-00 00:00:00.

maybe you have accidentaly set $timestamps to false in your model? — naneri, Mar 01 '16 at 06:58
Thanks, It should have worked without specifying, but I have set it to true either. — Arya Basiri, Mar 01 '16 at 07:00
@AryaBasiri Have you tried this `'created_at' => Carbon\Carbon::now()` ? — Doan Tran, Mar 01 '16 at 07:18
Yes that inserts correctly, but just created_at and updated_at are always null. I even change structure to datetime instead of timestamp that is default, but it didn't work either — Arya Basiri, Mar 01 '16 at 07:19
@DoanTran Thanks, it worked, but I thought if I don't put anything for that, it puts date and time correctly, Is there anyway not to use that Carbon? — Arya Basiri, Mar 01 '16 at 07:27

score 6 · Answer 1 · answered Mar 01 '16 at 07:26

The timestamp columns (created_at and updated_at) will be assigned automatically only if you are using the Eloquent like so:

$user = new \App\User;
$user->first_name = $first_name;
$user->last_name = $last_name;
$user->save();

When you are using query builder, you have to created_at and updated_at value by yourself:

DB::table('users')->insert([
    'first_name' => $first_name,
    'last_name' => $last_name,
    'created_at' => \Carbon\Carbon::now(),
    'updated_at' => \Carbon\Carbon::now(),
]);

Hope this will solve your issue.

No, I used first one exactly what you typed, again it didn't work :( — Arya Basiri, Mar 01 '16 at 07:34

score 2 · Answer 2 · answered Mar 16 '16 at 09:03

2

In the Model you should add this code,

public $timestamps = true;

created_at and updated_at will be updated automatically

answered Mar 16 '16 at 09:03

Andranik Petrosyan

92
1

score 1 · Answer 3 · answered Mar 26 '22 at 17:54

1

You have to use create method instead of insert method. Create method automatically add timestamp for created_at and updated_at field.

From Rakesh Nandi answer https://stackoverflow.com/a/54302128/3740246

answered Mar 26 '22 at 17:54

Andrea Mattioli

873
9
9

Laravel put null in created_at and updated_at while inserting new record

3 Answers3