Re: finding exactley when a record was inserted...

From: Sybrand Bakker <postmaster_at_sybrandb.demon.nl>
Date: Fri, 17 Dec 1999 21:51:12 +0100
Message-ID: <945467943.8842.0.pluto.d4ee154e@news.demon.nl>

The usual solution to this is to have a timestamp column in the table which has as default value sysdate.

Hth,

--
Sybrand Bakker, Oracle DBA
R. Nettleton <oradba_n_az_at_excite.com> wrote in message news:83e73j$5kv$1_at_nnrp03.primenet.com...
> I need to find out (if possible) how to get the date and time when a row
was
> inserted.
>
>
> Ron N.
>
>
Received on Fri Dec 17 1999 - 14:51:12 CST

This message: [ Message body ]
Next message: John Shaft: "Auto Increment Primary key?"
Previous message: Alex Krapivin: "Re: Userenv function"
In reply to: R. Nettleton: "finding exactley when a record was inserted..."
Next in thread: R. Nettleton: "Re: finding exactley when a record was inserted..."
Reply: R. Nettleton: "Re: finding exactley when a record was inserted..."

Contemporary messages sorted: [ by date ] [ by thread ] [ by subject ] [ by author ]

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US