kaman

YES, it does. Please read below mentioned example and explanation.

create table t (
a int,
b int,
timeUpdate timestamp,
timeEnter timestamp );

The first timestamp will always be the "automatically generated" time. So if the record is updated, or inserted, this time gets changed. If the order is changed, "timeEnter" is before "timeUpdate", then, "timeEnter" would get updated. First timestamp column updates automatically.

Note, in the table above timeEnter will only get updated if passed a null value.

insert into t (a,b,timeEnter) values (1,2,NULL);

Thank You for reading. Your valuable feedback are always appreciated.

sharma.s.prakash

nice information !!!!