Hi, I need to retrieve all the records from UserAccount table for last 2 days in Oracle Database. eg: UserAccount Table ------------------ UserID number UserName Varchar2. TimeStamp Date Any help is appreciated.
Joined: Apr 24, 2007
Hi, I have comeup with the following query. select * from USERACCOUNT WHERE TIMESTAMP >= sysdate and TIMESTAMP <= (sysdate -3). Yet to do the testing. If you have any other suggestions, please let me know. sudha