How to set default DateTime() in Laravel migrations?

laravel laravel-migrations
Alex Lomia picture Alex Lomia · May 10, 2016 · Viewed 24.8k times · Source

I am trying to achieve the functionality illustrated below:

$table->dateTime('time')->default(new \DateTime());

This exact code is failing, because

[ErrorException]
Object of class DateTime could not be converted to string

The other problem is, that I feel that there should be more robust/elegant way of solving this issue. So, how to correctly set a default DateTime value in migrations?

Answer

Gaurav Dave picture Gaurav Dave · May 10, 2016

Try this:

$table->timestamp('time')->useCurrent = true;

See, if that helps.

Related questions

Add a new column to existing table in a migration

I can't figure out how to add a new column to my existing database table using the Laravel framework. I tried to edit the migration file using... <?php public function up() { Schema::create('users', function ($table) { $table->integer("…

Read More
Laravel Migration Change to Make a Column Nullable

I created a migration with unsigned user_id. How can I edit user_id in a new migration to also make it nullable()? Schema::create('throttle', function(Blueprint $table) { $table->increments('id'); // this needs to also be nullable, how …

Read More
Artisan, creating tables in database

I am trying to create mysql tables in Laravel 5. I created a file in /project/database/migrations called users.php: [...] public function up() { Schema::create('users', function(Blueprint $table) { $table->increments('id'); $table->string('username'); $table->string(…

Read More