Mikael: Thanks - I must have missed that in the create table docs - I did look there first - honest!
And you are correct - in that the timestamp is too much precision, and unfortunately due to the thousands of distributed apps that access this DB, I cannot modify all the queries - oh well, guess it is just better to write a cron to modify the bad data :) Thanks for the info! On 11/13/03 10:28 AM, "Mikael Fridh" <[EMAIL PROTECTED]> wrote: > http://www.mysql.com/doc/en/CREATE_TABLE.html > > "A DEFAULT value has to be a constant, it cannot be a function or an > expression." > ... > "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." > > You have to use NOW() or CURRENT_DATE functions in your insert queries > instead. > > or read about the TIMESTAMP type, but I guess that's too much precision since > you only wanted the date, not the time. > http://www.mysql.com/doc/en/DATETIME.html > > Mike > > On Thursday 13 November 2003 16.15, Mike Morton wrote: >> I am trying to change a column specification, a date column, so that the >> default value is the current date. Is this possible? I just get an error >> on the change query: >> >> alter table Hits modify modify Date date NOT NULL default CURDATE(); >> >> ERROR 1064: You have an error in your SQL syntax. Check the manual that >> corresponds to your MySQL server version for the right syntax to use near >> 'date NOT NULL default CURDATE()' at line 1 >> >> Am I just stupid trying to have a function for a default? And if so, is it >> possible to get the 'current date' as the default value for a field? >> >> TIA! :) >> >> -- >> Cheers >> >> Mike Morton >> >> **************************************************** >> * >> * Tel: 905-465-1263 >> * Email: [EMAIL PROTECTED] >> * >> **************************************************** >> >> "Indeed, it would not be an exaggeration to describe the history of the >> computer industry for the past decade as a massive effort to keep up with >> Apple." >> - Byte Magazine >> >> Given infinite time, 100 monkeys could type out the complete works of >> Shakespeare. Win 98 source code? Eight monkeys, five minutes. >> -- NullGrey -- Cheers Mike Morton **************************************************** * * Tel: 905-465-1263 * Email: [EMAIL PROTECTED] * **************************************************** "Indeed, it would not be an exaggeration to describe the history of the computer industry for the past decade as a massive effort to keep up with Apple." - Byte Magazine Given infinite time, 100 monkeys could type out the complete works of Shakespeare. Win 98 source code? Eight monkeys, five minutes. -- NullGrey -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]