default value for date field

[skinny monkey]

I have probably the simplest table imaginable:

subscribtions (email, date_subscribed)

where date_subscribed is a DATE field, i was wondering how i can set the default value to be todays date, like NOW() but without the time?

[guido2004]

Maybe this?
http://dev.mysql.com/doc/refman/5.1/...nction_curdate

[skinny monkey]

that's what i thought originally, but when i run the following in mysql query browser i get an error:

ALTER TABLE `my`.`subscriptions` MODIFY COLUMN `date_subscribed` DATE DEFAULT CURDATE();

"mysql error number 1064 - check you have the right syntax to use CURDATE" (or words to that effect)