get Date time value from Oracle datestamp Gen Integer??

[Namshub]

I am using crystal reports to attempt to extract information from this database but I need to know which records were last updated. I have managed to find a field in Oracle and its value is based on a trigger function as shown below

begin

select TIMESTAMP_SEQ.nextval into :new.NURS_TIMESTAMP from dual;

end;

This at 9.45 on 05/09/2003 generated a value of 5,048,868

My main expertise is in SQL Server, my question is can I reverse engineer this value to calculate the time? Or is it like an identity field in SQL server (i.e. An automatic incremental counter)

I would really appreciate any help or pointers to some good web sources.

 

[stefanhei]

Hi.
The sequence you use is like an automatic incremental counter.
But you could add a field of type date and have your trigger like:
:new.your_tst := sysdate;

Stefan