List:General Discussion« Previous MessageNext Message »
From:Paul DuBois Date:January 13 2001 11:15pm
Subject:Re: DATE field with current date as default ?
View as plain text  
>Hello,
>
>Is there a way to have a field of type DATE get the current date as its
>default?

No.  Default values in MySQL must be constants.


>
>Something like ...
>
>mydatefield DATE DEFAULT curdate()
>
>...which does not work.  But that's the idea.


-- 
Paul DuBois, paul@stripped
Thread
DATE field with current date as default ?Nick Didkovsky13 Jan
  • Re: DATE field with current date as default ?Paul DuBois14 Jan
  • Re: DATE field with current date as default ?Scott Baker15 Jan