Member Avatar for rakeshiapps

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

  • 3 Contributors
  • 2 Replies
  • 108 Views
  • 3 Months Discussion Span
  • Latest Post Latest Post by like_to_learn

Recommended Answers

All 2 Replies

Member Avatar for debasisdas

please post your question clearly.

Member Avatar for 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)

Be a part of the DaniWeb community

We're a friendly, industry-focused community of developers, IT pros, digital marketers, and technology enthusiasts meeting, networking, learning, and sharing knowledge.