What is the default value when creating a Date Column in MySql Workbench?

Question

I am trying to create a column where the data type is Date (not datetime) in table which gets records ingested on a daily basis by an sh script. However, in MySql Workbench I need to set a default value. A date function doesn't work. If I put null, it generates a date for historical data, but from the moment the column is created everytime the table gets new records the result will be NULL for that field. Anyone faced this before? Picture attached.

Picture here

`2018/01/01` works. But... What value do you want? – Rick James May 03 '18 at 14:38 — Rick James, May 03 '18 at 14:38

score 1 · Accepted Answer · answered Apr 16 '18 at 23:04

1

Either change your field type to datetime & use default or use triggers on before insert.

What is the default value when creating a Date Column in MySql Workbench?

1 Answers1