Re: Get the date time from Oracle date time stamp?????

Hi Walt,

sorry, little correction inside.

"Walt" <walt_at_boatnerd.com.invalid> wrote news:3F58B90E.A71867CB_at_boatnerd.com.invalid...
>
> Although this field is named Timestamp_seq, it's not really a
 timestamp,
> it's just a sequence. Everytime you call TIMESTAMP_SEQ.nextval it
 gives
> you the previous value plus one (look up Sequence in your docs). I

If you also read this, you will see that there is no guarantee for 'previous value plus 1'. For many reasons...

> don't know how you would reverse engineer it to come up with a
 date/time
> of the last update, but you could use it to find the most recently
> updated record
>
> Select * from mytable where NURS_TIMESTAMP =
> (Select max(NURS_TIMESTAMP) from mytable)
>
> A little more work and you can return the last n updated records.
>
> HTH.
> --
> //-Walt
> //
> //

Greetings,
Guido Received on Mon Sep 08 2003 - 13:34:07 CEST