From: fvanbortel@netscape.net   
      
   Ric wrote:   
      
   > 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.45am (UK) 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.   
   Oracle dates are always WITH time!   
   The obvious internal pseudo column would be sysdate:   
      
   :new.NURS_TIMESTAMP := sysdate   
      
      
   --   
   Regards, Frank van Bortel   
      
   --- SoupGate-Win32 v1.05   
    * Origin: you cannot sedate... all the things you hate (1:229/2)