Is there anyway to specify as default value for a DATE column the current date?
I have tried with the following:
CREATE TABLE EXAMPLE (DB_ID NUMERIC(18,0) NOT NULL, DB_CREATIONDATE DATE('yyyy-MM-dd HH:mm:ss') DEFAULT SYSDATE NOT NULL);
but it doesn't insert anything in the DB_CREATIONDATE column.
Thanks in advance.
Regards,
Carmen
|
Supported now. Please download the latest package. You should use
CREATE TABLE EXAMPLE (DB_ID NUMERIC(18,0) NOT NULL, DB_CREATIONDATE TIMESTAMP('yyyy-MM-dd HH:mm:ss') DEFAULT SYSDATE() NOT NULL);
|
Main
webmaster@hxtt.com