Set the default value of a date column in Phinx migrations

Uncategorized
1

Hello,

I want to set the default of a date column to todays date using Phinx migrations.

I can use CURRENT_TIMESTAMP for datetime columns, but it doesn’t work for date columns. I have also tried CURRENT_DATE without success.

I’ve gone thru the documentation and cannot find an answer.

Is this possible using Phinx? I am using a MySQL database in my application.

Thanks, Dean.

2

Have you tried this?

'default' => \Phinx\Util\Literal::from('CURRENT_DATE()')
3

Yes, and it just throws an error when trying to create the table. I have tried a few different variations, but the generated SQL always adds in quotes around the (CURRENT_DATE) part that I need in the SQL.

Generated:

start_date DATE NOT NULL DEFAULT '(CURRENT_DATE)'

What I need:

start_date DATE NOT NULL DEFAULT (CURRENT_DATE)

4 
->addColumn('mydate', 'date', [
    'default' => \Phinx\Util\Literal::from('CURRENT_DATE')
])

make sure to NOT have the () at the end of CURRENT_DATE

5

Yep, tried this as well. Result:

`start_date` DATE NOT NULL DEFAULT 'CURRENT_DATE',

Also tried this:

'default' => \Phinx\Util\Literal::from('(CURRENT_DATE)')

result:
start_date DATE NOT NULL DEFAULT '(CURRENT_DATE)'

6

the code i posted above worked for me on cakephp 4.6.5 with phinx 0.13.4

1 Like