Skip to Main Content
Forums

APEX

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!

All datasets older than 8 hours - calculate with sysdate

617757Apr 11 2008 — edited Apr 11 2008
Hello,
I need to get all datasets, older than 8 hours.

I have a field :P200_DATE with the format: 11.04.2008 12:23

How can I calculate with this? As I mentioned, I need to subtract from the sysdate 8 hours.
Something like: (sysdate,'DD.MM.YYYY HH24:MI') - '08:00' ??


Thanks so much,
yours,
Elisabeth
Comments
Locked Post
New comments cannot be posted to this locked post.
Post Details
Locked on May 9 2008
Added on Apr 11 2008
#apex-discussions
4 comments
2,122 views