Oracle

can we display select command with from onedate to present date

Please support our Oracle advertiser: PostgreSQL or MySQL? Compare and contrast the two most popular open source databases

•

Join Date: Sep 2008

Posts: 1

Reputation: rakeshiapps is an unknown quantity at this point

Solved Threads: 0

rakeshiapps rakeshiapps is offline

Offline

Newbie Poster

can we display select command with from onedate to present date

Sep 8th, 2008

hi all,
can some one help me how to display the fields which enter in current week,current month like that

•

Join Date: Feb 2007

Posts: 2,104

Reputation: debasisdas will become famous soon enough

Solved Threads: 128

debasisdas debasisdas is offline

Offline

Postaholic

Re: can we display select command with from onedate to present date

Sep 12th, 2008

please post your question clearly.

Share your Knowledge.

•

Join Date: Dec 2008

Posts: 9

Reputation: like_to_learn is an unknown quantity at this point

Solved Threads: 0

like_to_learn like_to_learn is offline

Offline

Newbie Poster

Re: can we display select command with from onedate to present date

Dec 10th, 2008

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.