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!

Query help : Query to get values SYSDATE-1 18:00 hrs to SYSDATE 08:00 hrs

945284Apr 17 2013 — edited May 1 2013

Hi Team

I want the SQl query to get the data for the following comparison : -

Order Created is a Date Column , and i want to find out all the values from (SYSDATE-1) 18:00 hours to SYSDATE 08:00 hours
i.e.

(SYSDATE-1) 18:00:00 < Order.Created < SYSDATE 08:00:00.

Regards

This post has been answered by Karthick2003 on Apr 17 2013

Jump to Answer

Locked Post

New comments cannot be posted to this locked post.

Locked on May 29 2013

Added on Apr 17 2013

13 comments

3,084 views