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?