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

Locked Post

New comments cannot be posted to this locked post.

Locked on Jun 28 2016

Added on May 27 2016

16 comments

4,128 views