you can use TIMESTAMP data type, which have default NOW() ----- Original Message ----- From: "Riaan Oberholzer" <[EMAIL PROTECTED]> To: <[EMAIL PROTECTED]> 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/[EMAIL PROTECTED] > > -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]