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

[Brent Baisley]

If you update the row with NULL for the TIMESTAMP field it will enter 
the current date and time.

On Feb 5, 2004, at 7:18 AM, Martijn Tonies wrote:

>> 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.
>
-- 
Brent Baisley
Systems Architect
Landover Associates, Inc.
Search & Advisory Services for Advanced Technology Environments
p: 212.759.6400/800.759.0577