Re: [Q] setting DATE field with default NOW value?

[Martijn Tonies]

> 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