Hi Chris, Nope, DEFAULT values have to be constants; no functions or anything. :-/
What are you trying to do? And what's wrong with using TIMESTAMP since you want a default of NOW()? If it's because you don't want it update when you UPDATE the row, you can just set it to its current value, if you weren't aware of that. Matt ----- Original Message ----- From: "Chris Nolan" Sent: Saturday, January 03, 2004 10:34 AM Subject: Default DATE field values > Hi all, > > Upon reading the funky manual, I have discovered the following things: > > 1. TIMESTAMP fields can be set so that their default value is NOW(). > 2. DATE and TIMESTAMP fields are related. > > Given the two above facts, is there a way to set DATE columns so the > default value is NOW()? My playing around seems to have not produced any > fruitful results. > > Regards, > > Chris -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
