Re: Timestamp of insertion of the row.

"Anagha Joshi" <ajoshi@nulinkinc.com> wrote:
> Hi All,
> I mean to say ....
> Can I know the time when particular row is inserted into the table? i.e.
> timestamp of insertion of row into the table.

Is not clear what you want:

# begin transaction;            // 10:00:00 AM
[ 3 minutes of delay ( computation, others rows inserted, ... ]
# insert row                       // 10:03:00 AM
# end transaction;

if you use default now() you will have on the time stamp:  10:00:00 AM
if you use default timeofday() you will have on the time stamp:   10:03:00
AM


regards
Gaetano Mendola