Skip to Main Content

SQL & PL/SQL

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

Data for the last 30 hours

Lucky7May 27 2016 — edited May 31 2016

Hi,

I have a column with date and time and the data needs to be fetched for the last 30 hours.

SYSDATE - 1 will give me the data for last 24 hours but how can i get the data for the last 30 hours.

Please provide some suggestions.

Thanks,

Lucky

Comments
Locked Post
New comments cannot be posted to this locked post.
Post Details
Locked on Jun 28 2016
Added on May 27 2016
16 comments
4,121 views