List:General Discussion« Previous MessageNext Message »
From:Brent Baisley Date:February 5 2004 3:32pm
Subject:Re: [Q] setting DATE field with default NOW value?
View as plain text  
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

Thread
[Q] setting DATE field with default NOW value?Riaan Oberholzer5 Feb
  • Re: [Q] setting DATE field with default NOW value?Martijn Tonies5 Feb
  • Re: [Q] setting DATE field with default NOW value?KKoTY5 Feb
  • Re: [Q] setting DATE field with default NOW value?Martijn Tonies5 Feb
    • Re: [Q] setting DATE field with default NOW value?Brent Baisley5 Feb