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!

Help needed in sysdate

user497267Dec 9 2009 — edited Dec 9 2009
Hi,

If we use "sysdate-1" in my query its doing 24 hours minus from sydate. Is it possible to get output starting from 12AM using sysdate-1.

For example the below query is resulting the values which are greater than sysdate -1 (exactly 24 hours from sysdate), is it anyway to result the values from 12AM.

select * from test
where date_start >sysdate -1

Thanks
Comments
Locked Post
New comments cannot be posted to this locked post.
Post Details
Locked on Jan 6 2010
Added on Dec 9 2009
7 comments
1,058 views