Skip to Main Content
Forums

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!

date is greater than current time plus 24 hours

tparvaizMay 26 2013 — edited May 27 2013
Hi,

may I know how to pull data from a table where date is greater than current time (+24 hours)... my date field is in the following format 15-MAR-2013 20:07:00

I want to do something like this


select * from table_A where date_field > (sys_date_time) +24h


as an example, when I run a query @ 4 PM on March 26, I want to pull data that has date > 4 PM March 27

Thanks
Comments
Locked Post
New comments cannot be posted to this locked post.
Post Details
Locked on Jun 24 2013
Added on May 26 2013
6 comments
14,871 views