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

Content reproduced on this site is the property of the respective copyright holders. It is not reviewed in advance by Oracle and does not necessarily represent the opinion of Oracle or any other party.