defaulting date/time to current

Would this work in a CREATE TABLE command: create table "form" (
"form_number" char(8) not null,

...
"form_revision_date" date default (select to_char(sysdate, 'yyyy-mm-dd
hh24:mi:ss') from dual;) not null,
...
);

Or (even if it doesn't produce a syntax error) would that make the date/time always default to the date/time when the table was created.

Thanks,
-Mark Received on Wed Oct 02 2002 - 20:55:01 CEST