Query retrun empty record

[pearl_123]

hi to all,

i execute these query but these return empy result although record exist between these dates

SELECT * FROM nisanj_users WHERE reminder_datum BETWEEN '2009-02-20' AND '2009-02-10'

or

SELECT * FROM nisanj_users WHERE reminder_datum < '2009-02-20' AND reminder_datum > '2009-02-10'

i want to get all records between two dates from mysql

regards,

[r937]

the first one is obviously wrong, because this --

WHERE reminder_datum BETWEEN '2009-02-20' AND '2009-02-10'

is equivaluent to this --

WHERE reminder_datum >= '2009-02-20' 
  AND reminder_datum <= '2009-02-10'

and of course that's impossible for all values

the second one should work

[guido2004]

Try casting the date strings as DATE
http://dev.mysql.com/doc/refman/5.1/...erator_between
http://dev.mysql.com/doc/refman/5.1/...#function_cast

[r937]

'2009-02-10' is a valid mysql date string, there's no need to cast it

[guido2004]

'2009-02-10' is a valid mysql date string, there's no need to cast it

Ok. That's what I thought too. But then I read this in the MySQL reference manual:
"If you use a string constant such as '2001-1-1' in a comparison to a DATE, cast the string to a DATE."

And I thought that it might be worth a try, since the OP is claiming his 2nd query (the one that should work), isn't working.