why does laravel migration's timestapce('my_col_name') returns Syntax error or access violation: 1067 Invalid default value for 'my_col_name'

Question

In my migration I have two extra timestamp

$table->timestamp('starts_at');

$table->timestamp('ends_at');

I dont want them to be nullable,problem is,when i run php artisan migrate I returns

Syntax error or access violation: 1067 Invalid default value for 'ends_at'

I have $table->timestamps() at the bottom. How can I have my custom timestamp column/s and not nullable

A way around is to simply put nullable() at the end but its not a fix.using laravel 5.7

Do you already have records in the table? If so, you either need to make these timestamps nullable, set a default, or empty the table and then migrate. — Stefan Teunissen
i have no data in that table,its a fresh migration after running php artisan make:migration my_migration_name — user7116461

Prashant Prajapati Prashant Prajapati · Accepted Answer · 2019-02-21T12:43:27

I hope you are looking for datetime data type for that field. Try the below code.

$table->datetime('starts_at');
$table->datetime('ends_at');

if you want to make this field as nullable try below.

$table->dateTime('starts_at')->nullable();
$table->dateTime('ends_at')->nullable();