Some years ago, I faced this bug in MySQL Workbench:
- Create a table
- Add a column with type datetime
- Go to the query editor
- Try to insert now() into the datetime field
Result: It will not work.
Reason, if you take a look at the query you will see the following:
`test_date`='now()'
Ok, the solution is easy, "now()" must be written without the single quotes. To do this type:
\func now()
instead of
now()
