From: Martijn Tonies
Date: February 5 2004 11:46am
Subject: Re: [Q] setting DATE field with default NOW value?
List-Archive: http://lists.mysql.com/mysql/159020
Message-Id: <02f601c3ebdd$a493df40$0e02a8c0@martijn>
MIME-Version: 1.0
Content-Type: text/plain;
	charset="iso-8859-1"
Content-Transfer-Encoding: 7bit

Hi,


> 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?

According to the documentation for the DEFAULT <value>
clause, <value> can only be a real value. Not a function.

So basically, you're out of luck.

With regards,

Martijn Tonies
Database Workbench - developer tool for InterBase, Firebird, MySQL & MS SQL
Server.
Upscene Productions
http://www.upscene.com