Mysql Date between query not working

Question

I'm trying the following and not working - producing zero results.

Quite tired after a 20hr + programming marathon but can't spot the mistake.

select count(*) from app where lastUpdate Between 2013-11-10 AND 2013-11-21

Query structure seems to be OK. But don't you get error message because dates are not quoted? — Alex
– Alex, Commented Nov 21, 2013 at 22:36
Apparently this happens: stackoverflow.com/a/20133449/1688441 — Μenelaοs
– Μenelaοs, Commented Nov 21, 2013 at 22:42

amaster · Accepted Answer · 2013-11-21 22:41:37Z

4

When dates are not quoted then they would perform calculations which would make the query actually be:

select count(*) from app where lastUpdate Between 1992 AND 1981

answered Nov 21, 2013 at 22:41

amaster

2,1536 gold badges28 silver badges55 bronze badges

Sign up to request clarification or add additional context in comments.

Comments

user1864610 · Accepted Answer · 2013-11-21 22:36:34Z

2

No schema, but try:

select count(*) from app where lastUpdate Between '2013-11-10' AND '2013-11-21'

answered Nov 21, 2013 at 22:36

user1864610