Default value for date type

Help
,
1

I am trying to add a field of type date that has a default value but CURRENT_DATE does not seem to work.

ALTER TABLE `t` ADD `created` DATE
NOT NULL
DEFAULT CURRENT_DATE()
AFTER `f`

You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'CURRENT_DATE()

2

Welcome Amyf! :wave:

Sorry to hear you are having this difficulty. We’re happy to help.
Are you running on a managed or self-hosted service and what version number?

3

Hey Maria,

Thanks so much! It’s managed and on version 7.6.22