Skip to Main Content

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!

Interested in getting your voice heard by members of the Developer Marketing team at Oracle? Check out this post for AppDev or this post for AI focus group information.

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
14 comments
40,731 views