How to make a substitution of the current date, by default?

Question

SQL

I tried this: it
date_now DATETIME() default NOW(),
gives an error.

Answer 1

DEFAULT CURRENT_TIMESTAMP

Answer 2

only timestamp can take the value of current_timestamp, there is no such feature for the datetime field