I have a doubt in oracle!

[Arun Soundar]

I want to get the data from the database such that I would get the data between 2 dates inclusive of the given dates. Using Between function returns only the data between the 2 dates without including the from date.

[Paul Sturrock]

I think you've misunderstood the Oracle documentation; you can understand "between" to mean "greater than or equal to the first value, and less than or equal to the second". So:

<param> BETWEEN 1 AND 10

means that the value of <param> is any value in the set {1, 2, 3, 4, 5, 6, 7, 8, 9, 10}.

An result of this is that the between comparison operator implicitly requires ordering. If I wrote it the other way:

<param> BETWEEN 10 AND 1

This would only return true if the value of <param> was not in the set {2, 3, 4, 5, 6, 7, 8, 9}.

[ January 17, 2005: Message edited by: Paul Sturrock ]
[ January 17, 2005: Message edited by: Paul Sturrock ]