6.Like-II


#1

Why does

SELECT * FROM movies
WHERE name BETWEEN 'A' AND 'J';

return movies with names that begin with letters "A" up to but not including "J"

BUT

SELECT * FROM movies WHERE year BETWEEN 1990 AND 2000;

returns and includes all movies with that range and also includes year 2000 movies?

Thanks!


#2

@cloudpro17985,
Found with google search
== discussions / opinions =
sql between behaviour site:stackoverflow.com
for instance
http://stackoverflow.com/questions/23733902/different-behavior-of-between-operator-in-oracle