Re: date field - default value = current date

[Paul DuBois]

At 1:32 -0700 9/18/02, neal wrote:
>Is there a wat to have mySQL auto fill in the current date into my
>dateCreated field?
>
>In SQLServer I would simply specify the getDate() method as a default value.
>I presume I would use the analogous MySQL function curDate() but it does not
>appear to work for me.

It's better to read the manual than to presume.  In this case, the
presumption is incorrect.  Default values in MySQL must be constants.

However, you might find the TIMESTAMP column type helpful.
I'll let you read about it in the manual. :-)

http://www.mysql.com/doc/en/DATETIME.html

>
>Any suggestions?