List:General Discussion« Previous MessageNext Message »
From:Paul DuBois Date:April 5 2002 1:28am
Subject:Re: How to specify sysdate as default?
View as plain text  
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. :-)
Thread
How to specify sysdate as default?James Hedrick5 Apr
  • Re: How to specify sysdate as default?Paul DuBois5 Apr