SQL plages de dates [closed]

by

For each operator (ie < or > ) there must be a distinct right and left side.

When you write datedebut < 20181109 < datefin it is parsed as datedebut < 20181109 and the result of that comparison is sent to the next operator.

You need to think differently when writing SQL than when writing mathematics. You can argument that both “languages” have parsers, but they are slightly different.

EDIT comment:
As I have been made aware in the comments, My original answer was not entirely correct, since that would ave given a parse error. The essence is correct: Your query is not being parsed as you expected.

As others have answered, if you want a more compact answer, you need to use the BETWEEN keyword instead of the <and > operators.

More Related Contents:

  1. How do I store large no.of small entries in Mysql?
  2. Insert into a MySQL table or update if exists
  3. “Incorrect string value” when trying to insert UTF-8 into MySQL via JDBC?
  4. WHERE vs HAVING
  5. Location of my.cnf file on macOS
  6. Search for “whole word match” in MySQL
  7. Connect to mysql on Amazon EC2 from a remote server
  8. Docker-compose check if mysql connection is ready
  9. SQL: selecting rows where column value changed from previous row
  10. What is the location of mysql client “.my.cnf” in XAMPP for Windows?
  11. MySQL WHERE IN ()
  12. How to skip certain database tables with mysqldump?
  13. Using MySql with Entity Framework 4 and the Code-First Development CTP
  14. MySQL error 1241: Operand should contain 1 column(s)
  15. MySQL treats ÅÄÖ as AAO?
  16. MySQL – Supertype/Subtype design
  17. How can write queries in MySQL that can parse JSON data in a column?
  18. MySQL Time Zones
  19. How to use django models with foreign keys in different DBs?
  20. mysql_fetch_row() vs mysql_fetch_assoc() vs mysql_fetch_array() [duplicate]
  21. Mysql select where not in table
  22. How can I undo a mysql statement that I just executed?
  23. Continue SQL query even on errors in MySQL workbench
  24. Which DATATYPE is better to use TEXT or VARCHAR?
  25. How to generate a UUIDv4 in MySQL?
  26. is php sort better than mysql “order by”?
  27. How can “set timestamp” be a slow query?
  28. Update multiple rows with multiple ‘where’ clauses for each individual row
  29. WHERE datetime older than some time (eg. 15 minutes)
  30. Is there a way to use ON DUPLICATE KEY to Update all that I wanted to insert?

Leave a Comment