From: Martijn Tonies
Date: February 5 2004 12:18pm
Subject: Re: [Q] setting DATE field with default NOW value?
List-Archive: http://lists.mysql.com/mysql/159022
Message-Id: <033001c3ebe2$311f58a0$0e02a8c0@martijn>
MIME-Version: 1.0
Content-Type: text/plain;
	charset="iso-8859-1"
Content-Transfer-Encoding: 7bit




> you can use TIMESTAMP data type, which have default NOW()

Not exactly.

1) TIMESTAMP also updates when you update the row, unless
  you set the column value to its current value.

2) not in "maxdb" mode.

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

> > In a table definition, how do I get a date field to be
> > assigned as DEFAULT the current date?

With regards,

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