Default Expressions - help

Hi All,

Im trying to add this default expression, but getting failed Expression : DATE_SUB(NOW(),INTERVAL 1 DAY)

Please find below the exisiting table structure

Trying to add a column with default expression -> DATE_SUB(NOW(),INTERVAL 1 DAY)

Am i doing any mistake or is it bug?

Thanks!

Support for default expressions depend on the column type, and on the server version. I would look up what your server supports here in their online documentation.

My MYSQL version is 8.0.17

Any suggestion for me to achieve this?