Skip to Main Content

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!

between two dates but inclusive of the dates

789736Aug 20 2012 — edited Aug 20 2012
Hi guys

Quick date question. I have a start date and an end date, its actually stored as datetime on the datebase but im only interested in the date portion. I want to check if a given date is between my start and end date INCLUSIVE of the start and end date and was just wondering what the best way to do this is?

Thanks for any help I may get.
Comments
Locked Post
New comments cannot be posted to this locked post.
Post Details
Locked on Sep 17 2012
Added on Aug 20 2012
8 comments
20,794 views