db-torque-user 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 in oracle
Date Tue, 09 Sep 2003 15:26:47 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'
);

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

CREATE TABLE MY_TABLE
(
    MY_DATE_FIELD DATE default sysdate
);

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


-Gary

Mime
  • Unnamed multipart/alternative (inline, None, 0 bytes)
View raw message