Select query doesn't show result but no error in query

[සශික]

I used mysql query broweser to create database and tables. but when I run this code it doesn't show results. But there is no error

SELECT * FROM expenses
WHERE datee BETWEEN 01/01/2016 and 01/09/2016;

can anyone help me ?

[pritaeas]

You are missing quotes for one, try this:

SELECT * FROM expenses
WHERE datee BETWEEN '2016-01-01' and '2016-09-01';

[සශික]

thank you two guys :)