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!

How to get the date from sysdate plus number of hours

435184Jan 31 2009 — edited Jan 31 2009

Hi,

How can I get the date if I have numbr of ours. e.g. I need to find what will be the date in next 90 hrs starting from sysdate. i.e. if sysdate is Jan 20 8 a.m and if need to find the date in next 48 hrs it showuld give me JAN 22. How can I get this in sql

Thanks

Locked Post

New comments cannot be posted to this locked post.

Locked on Feb 28 2009

Added on Jan 31 2009

2 comments

892 views