This content has been marked as final. Show 3 replies
trunc(sysdate + 1) is adding 1 day in sysdate and then truncating
trunc(sysdate) + 1 truncating sysdate and then is adding 1 day
output will be same.
There is no difference1 person found this helpful
In your case (adding 1)Different in execution order, but the same result.
But let's say you are adding 0.9, it will return different result.