Im trying to select a timestamp range from a mysql database and im having problems, no idea why.
I have the table 'pedido' and the field 'fecha' which is set as timestamp. I have lots of entries so that should not be the problem.
However when y select with this query:
SELECT * FROM pedido WHERE fecha BETWEEN UNIX_TIMESTAMP('2011-10-10') AND UNIX_TIMESTAMP('2011-11-10') ORDER BY fecha DESC
I get no response.
Thanls for the help