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

Reply via email to