MySQL DATE syntax FAQ: How do I set a MySQL DATE field to default to "now", i.e., the current time?
MySQL default date now - Solution
Unfortunately you can't default a MySQL DATE field to "now", but you can get the "now" behavior with a MySQL TIMESTAMP field. The basic MySQL syntax to create a MySQL TIMESTAMP now field is:
last_changed timestamp not null default now(),
where "last_changed" is the name of my field, timestamp is the type of field, it can't be null, and the date/time default is now.