MySQL Workbench: Can't apply NOW() to timestamps field

Question

I get this problem with applying now() to timestamp field. It just doesn't automatically fill in the field with the current time. I tried both now() and NOW() and also current_time, doesn't work either. What can be the problem? What other values I can insert into the field in order to get the current time?

Answer 1

If you want to edit data directly in the Result Grid, for functions add "\func" before that function. In this case try this:

\func now()

it will be now() in the query you will see in Apply SQL Script to Database window.

Answer 2

Use now() in query without quotes:

Insert into blog.task(body,created_at ,updated_at)values('some values',now(),now());