Set default value to a date field (in migration)

$table->date('data')->default(date("Y-m-d H:i:s"));

It has to be timestamp.

@aurawindsurfing that would result in a fixed date (now) as the default, whereas the OP needs CURRENT_TIMESTAMP.

@aurawindsurfing : that seems to work, but would it be a different date for each day I add a new record? Or will it always use the same value?

EDIT: oh as I thought it'll be a fixed date, yeah as @tykus said I need to emulate the CURDATE() function of MySQL. I thought Expression was the way to go, but maybe I misunderstood what it does...

You need ->default(DB::raw('CURRENT_TIMESTAMP')) @n00bcod3r - otherwise, the migration will fix the datetime that the migration was run.

@tykus I'm getting this error:

SQLSTATE[42000]: Syntax error or access violation: 1067 Invalid default value for 'data' (SQL: ALTER TABLE selezioni_stampa CHANGE data data DATE DEFAULT 'CURRENT_TIMESTAMP' NOT NULL)

I think it's because the type is date and not datetime? That's why I wanted to use the CURDATE() function, but I still get the same error

PS: I'm using a ->change() function that's why it's an ALTER TABLE and not a CREATE

Whats the difference between now(); and CURRENT_TIMESTAMP? Quick google returned that they are the same thing: https://dev.mysql.com/doc/refman/8.0/en/date-and-time-functions.html#function_current-timestamp

@aurawindsurfing not sure about this, but I think that now() won't call the MySQL function but the Laravel helper method: https://laravel.com/docs/8.x/helpers#method-now

You are using the Carbon now() @aurawindsurfing - it will be evaluated (in PHP) at runtime to a fixed datetime.

Anyway I don't this can be achieved, since I can't change the type to Datetime... I've done some tests from PHPMyAdmin and it's not possible to set it as CURDATE() or CURRENT_TIMESTAMP

What is your mysql version? For <8.0.13, your default is not able to take an expression

With one exception, the default value specified in a DEFAULT clause must be a literal constant; it cannot be a function or an expression. This means, for example, that you cannot set the default for a date column to be the value of a function such as NOW() or CURRENT_DATE. The exception is that, for TIMESTAMP and DATETIME columns, you can specify CURRENT_TIMESTAMP as the default.

https://dev.mysql.com/doc/refman/8.0/en/data-type-defaults.html

@tykus the version is 5.7.24, I'm gonna update it I guess

Why not use a TIMESTAMP data type?

The DB owner told me I cannot change the type...

The DB owner told me I cannot change the type...

But you can upgrade the version?

Well actually I'm using an older version in my local machine, so I wouldn't change the version since they always keep it up to date... Having troubles upgrading the version in my machine but that's not the topic so I'll ask somewhere else :)

I know that this is old, but I was recently facing the same issue.

These both worked for me:

        $table->date('registration_date')->default(DB::raw('(CURDATE())'));
or
        $table->date('registration_date')->default(new Expression('(CURDATE())'));

MySQL doesn't like that Laravel omits the surrounding parenthesis for default values of expressions.

I ran into a similar problem:

SQLSTATE[42000]: Syntax error or access violation: 1067 Invalid default value for 'track_release_date'

I found a solution in the documentation (I use Laravel 8 and MySQL 8): https://laravel.com/docs/8.x/migrations#column-modifiers

->useCurrent()              Set TIMESTAMP columns to use 
                            CURRENT_TIMESTAMP as default value.
->useCurrentOnUpdate()      Set TIMESTAMP columns to use 
                            CURRENT_TIMESTAMP when a record is updated.

this ran successfully:

$table->dateTime('track_release_date')->useCurrent();