you can use TIMESTAMP data type, which have default NOW()
----- Original Message -----
From: "Riaan Oberholzer" <riaanoberholzer@stripped>
To: <mysql@stripped>
Sent: Thursday, February 05, 2004 12:38 PM
Subject: [Q] setting DATE field with default NOW value?
> In a table definition, how do I get a date field to be
> assigned as DEFAULT the current date?
>
> I tried:
>
> dateField DATE DEFAULT CURDATE()
>
> but that gives me syntax errors....
>
> Help?
>
>
> __________________________________
> Do you Yahoo!?
> Yahoo! Finance: Get your refund fast by filing online.
> http://taxes.yahoo.com/filing.html
>
> --
> MySQL General Mailing List
> For list archives: http://lists.mysql.com/mysql
> To unsubscribe: http://lists.mysql.com/mysql?unsub=1
>
>
