Defaulting a date column without using timestamp 1

[cDevX99]

Is there a way to have a date type column default to the current date without using time stamp. The reason is that I want to store the creation date of a record, but I do not want that date to change on subsequent updates. I have tried to do this using both CURRENT_DATE and curdate() to no avail.

 

[devnull22]

when the record is created use the NOW()
ie.
INSERT INTO table_name (col1,col2,create_date)
VALUES ('val1','val2',NOW())

then when u modify the record, just don't modify the date col.

cheers
devnull22

http://www.photoflux.com

http://www.clickEval.com

--
Apparently if you play the Windows NT CD backwards you hear satanic messages. If you think that's bad, play it forwards and it installs Windows NT !

 

[cDevX99]

Thanks, I ended up doing something very similar to that, can it really be possible that there is no way to make the current date the default for a date col in MySQL??? It seems to be the case. Thanks for the help.