Skip to Main Content
Forums

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!

Using TRUNC(SYSDATE) between

Christine1111Sep 21 2011 — edited Sep 21 2011
Hello - I have a question about when to use TRUNC(SYSDATE).

In particular, I'm wondering whether or not there is any reason to use TRUNC(SYSDATE) in the following statement:
select app_id from app where sysdate between start_date and stop_date
....where start_date and stop_date are stored truncated (no time info stored in column).

Thanks!
This post has been answered by John Spencer on Sep 21 2011
Jump to Answer
Comments
Locked Post
New comments cannot be posted to this locked post.
Post Details
Locked on Oct 19 2011
Added on Sep 21 2011
5 comments
714 views