Default date

Hello all,

I have a field of type DATE and i like to have a default value for this
field set to the current date. Is this possible to do this in the create
table statement?

ie

CREATE TABLE mytable
(
...
mydate DATE DEFAULT "function to insert current date",
...

)


thanks in advance
Roger