default value for date field

[mahadev sawale]

hi frnds,
how can i set default value for the date field?
for example, i have a column
valid date;

when i try to set the default value like
alter table t modify column valid date not null default current_date;
it shows the errors;

i know timestamp works, but i want only date field.

thanks.