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

Locked Post

New comments cannot be posted to this locked post.

Locked on Oct 11 2011

Added on Sep 13 2011

2 comments

612 views