Re: Default DATE field values

2004-01-04 Thread Chris Nolan
Hi, Firstly, thanks for the reply. I'm aware that MySQL requires that default values be constants without reference to expressions that need to be evaluated and the fields in question will never be updated - it's a set-once thing. The reason I asked is due to the information in the MySQL manual

Re: Default DATE field values

2004-01-03 Thread Matt W
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 y