timestamp is automatically updated
-Original Message-
From: George Labuschagne [mailto:[EMAIL PROTECTED]]
Sent: Friday, February 15, 2002 1:20 PM
To: [EMAIL PROTECTED]
Subject: When does the timestamp field gets updated?
Hi all,
If one uses the timestamp data type for a column inside
Only the first TIMESTAMP field gets updated when an updat to a record is
made, so if you want to maintain the time a record was created, and when it
was updated, use two timestamp fields, the first field will be the time
updated, but to do this you must initialize the second timestamp field
George/Rick, a quick addition.
It is not clear from the question: do you want to have the timestamp updated, or do
you want to leave it be?
RTFM:
6.2.2.2 The DATETIME, DATE, and TIMESTAMP Types
...
The TIMESTAMP column type provides a type that you can use to automatically mark
INSERT or