Unless you change the logic
to include a +1, as you indicated. If you use a trunc, however, you always know where you stand.
Of course, you might need to add a functional index to the table as well.
Personally, I might throw sysdate into a variable and use that instead, depending on where this is being used.
Side note: in our system, we have a function to wrap sysdate. This lets us actually set sysdate to whatever we want for testing purposes. We're also guaranteed to always get the exact same date within the same session call. This doesn't work for sessions that aren't ended between calls, of course.
