Posted by Rob on 05/13/05 10:58

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

[Back to original message]