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!

TRUNC(SYSDATE) question

DBA112Jan 14 2013 — edited Jan 14 2013
Dear SQL Experts,

Can you clarify the difference b/w the below 2 conditions. I see same results with either of the conditions. I'm trying to pull data for 24 hours and this is one of the conditions I'm using in the SQL:
trunc(BEGIN_INTERVAL_TIME) between trunc(sysdate-1) and trunc(sysdate-1)

trunc(BEGIN_INTERVAL_TIME) between trunc(sysdate-1) and trunc(sysdate)

Edited by: DBA112 on Jan 14, 2013 1:57 PM
This post has been answered by unknown-7404 on Jan 14 2013
Jump to Answer
Comments
Locked Post
New comments cannot be posted to this locked post.
Post Details
Locked on Feb 11 2013
Added on Jan 14 2013
#11g
14 comments
41,051 views