using between operator
784355Sep 13 2011 — edited Sep 13 2011Hello,
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