db-torque-dev mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From "Gary Baker" <gary.ba...@movielink.com>
Subject "sysdate" as default value for oracle
Date Thu, 04 Sep 2003 17:29:18 GMT
There is a problem when specifying "sysdate" default value for a date
column.

<table name="MY_TABLE">
        <column name="MY_DATE_FIELD" type="DATE" default="sysdate"/>
</table>

Yields the following create table statement...

CREATE TABLE MY_TABLE
(
    MY_DATE_FIELD DATE default 'sysdate' NOT NULL
);

This is an invalid create table statement.  The following is correct
(sans quotes)...

CREATE TABLE MY_TABLE
(
    MY_DATE_FIELD DATE default sysdate NOT NULL
);

Has this been addressed?  I wasn't able to find any posts in the
archives addressing this issue.  
Anyone know where this code is?


---------------------------------------------------------------------
To unsubscribe, e-mail: torque-dev-unsubscribe@db.apache.org
For additional commands, e-mail: torque-dev-help@db.apache.org


Mime
View raw message