Re: can we display select command with from onedate to present date
I think below queries may help you.........................
To see the one day before data, use the following Query: select * from <table_name) as of timestamp (systimestamp - interval '1' day)
To see the one Hour before data, use the following Query: select * from <table_name) as of timestamp (systimestamp - interval '1' hour)
Last edited by peter_budo; Dec 12th, 2008 at 7:13 am. Reason: Keep It Organized - For easy readability, always wrap programming code within posts in [code] (code blocks) and [icode] (inline code) tags.
No one has posted to this discussion for at least three months. Please let old threads die and do not reply to them unless you feel you have something new and valuable to contribute that absolutely must be added to make the discussion complete. Otherwise, please start a new thread in this forum instead.
Unsolved 
