Skip to Main Content
Forums

Database Software

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!

Difference b/w trunc(sysdate)-1 and trunc(sysdate -1)

PhantasmOct 24 2008 — edited Jul 26 2010
Is there any difference b/w trunc(sysdate)-1 and trunc(sysdate -1).Though they functionally give the same result, is there any difference in the performance or any other factor.
Comments
Locked Post
New comments cannot be posted to this locked post.
Post Details
Locked on Aug 23 2010
Added on Oct 24 2008
#data-warehousing, #warehouse-builder
7 comments
20,793 views