At 20:25 -0500 4/4/02, James Hedrick wrote:
>Hi Gang,
>I am currently specing out a table in MySQL manager and I am trying to set
>sysdate as default value for ActivityDate column ( a datetime field). If I
>specify sysdate() in default value field then the DDL changes to show
>default as "default '0000-00-00 00:00:00'". What am I doing wrong?
>
>Thanks,
>James
You're not believing the manual, which says that default values must
be constants. :-)

Content reproduced on this site is the property of the respective copyright holders. It is not reviewed in advance by Oracle and does not necessarily represent the opinion of Oracle or any other party.