Re: Feature request: using CURRENT_DATE as DEFAULT value

2003-03-06 Thread gerald_clark
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 t

Re: Feature request: using CURRENT_DATE as DEFAULT value

2003-03-05 Thread Paul DuBois
At 17:56 -0800 3/5/03, 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 "fix

Feature request: using CURRENT_DATE as DEFAULT value

2003-03-05 Thread Daevid Vincent
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 cre