Skip to Main Content

SQL Developer

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 manipulation

VGAOct 10 2017 — edited Oct 10 2017

Hi everyone,

I'm making a query that's supposed to pull out the data between previous day 1900 hours and current day 18:59:59 hours.

This query will be added in a report that get's refreshed on a daily basis but at different hours so can't use sysdate - 1.

I'm using oracle sql developer  Version 4.0.1.14.

Thanks in advance!

Comments

Processing
Locked Post
New comments cannot be posted to this locked post.

Post Details

Locked on Nov 7 2017
Added on Oct 10 2017
6 comments
120 views