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!

using between operator

784355Sep 13 2011 — edited Sep 13 2011
Hello,

I am using Oracle Database 11g Enterprise Edition Release 11.2.0.2.0
I am using between operator in date field,read that the between opertaor takes the inclusive of the second value.
But i am not getting that way,its taking exclusive of the last value.

For e.g
ud is timestamp.
ud between to_date('01-Sep-2010','DD-Mon-YYYY') and to_date('31-Aug-2011','DD-Mon-YYYY')
is excluding the dat 31-Aug.Its just showing the data only till 30Aug.

May be the reason is because its a timestamp,in such case how to include 31Aug data also without doing to_date('01-Sep-2011','DD-Mon-YYYY')

Thanks
This post has been answered by 523861 on Sep 13 2011
Jump to Answer
Comments
Locked Post
New comments cannot be posted to this locked post.
Post Details
Locked on Oct 11 2011
Added on Sep 13 2011
2 comments
612 views