List:General Discussion« Previous MessageNext Message »
From:gerald_clark Date:March 6 2003 2:16pm
Subject:Re: Feature request: using CURRENT_DATE as DEFAULT value
View as plain text  
Perhaps TIMESTAMP will provide what you need.

Daevid Vincent wrote:

>http://www.mysql.com/doc/en/CREATE_TABLE.html states "Default values must be
>constants. This means, for example, that you cannot set the default for a
>date column to be the value of a function such as NOW() or CURRENT_DATE."
>
>Is this ever going to be "fixed"? I often find myself using this when
>creating new records, and it'd be just one less thing to worry about putting
>in the INSERT statement?
>
>
>  
>


Thread
Feature request: using CURRENT_DATE as DEFAULT valueDaevid Vincent6 Mar
  • Re: Feature request: using CURRENT_DATE as DEFAULT valuePaul DuBois6 Mar
  • Re: Feature request: using CURRENT_DATE as DEFAULT valuegerald_clark6 Mar