Win a copy of Re-engineering Legacy Software this week in the Refactoring forum
or Docker in Action in the Cloud/Virtualization forum!
  • Post Reply
  • Bookmark Topic Watch Topic
  • New Topic

I have a doubt in oracle!

 
Arun Soundar
Greenhorn
Posts: 1
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
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
Bartender
Posts: 10336
Eclipse IDE Hibernate Java
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
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:

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:

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 ]
 
  • Post Reply
  • Bookmark Topic Watch Topic
  • New Topic