can we display select command with from onedate to present date

[rakeshiapps]

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

[debasisdas]

please post your question clearly.

[like_to_learn]

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)