TRUNC(SYSDATE) question
DBA112Jan 14 2013 — edited Jan 14 2013Dear 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