Knowing when a row was last updated

Started by Antony Paulover 21 years ago2 messagesgeneral
Jump to latest
#1Antony Paul
antonypaul24@gmail.com

Hi all,
Is it possible to know when a row was last updated. Using 7.3.3.

rgds
Antony Paul

#2Michael Fuhr
mike@fuhr.org
In reply to: Antony Paul (#1)
Re: Knowing when a row was last updated

On Wed, Nov 17, 2004 at 07:43:31PM +0530, Antony Paul wrote:

Is it possible to know when a row was last updated. Using 7.3.3.

Add a TIMESTAMP or TIMESTAMP WITH TIME ZONE column to the table and
use a trigger to update it.

--
Michael Fuhr
http://www.fuhr.org/~mfuhr/