Member Avatar for සශික

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 ?

  • 2 Contributors
  • 2 Replies
  • 121 Views
  • 12 Hours Discussion Span
  • Latest Post Latest Post by සශික

Recommended Answers

All 2 Replies

Member Avatar for pritaeas

You are missing quotes for one, try this:

SELECT * FROM expenses
WHERE datee BETWEEN '2016-01-01' and '2016-09-01';
Member Avatar for සශික

thank you two guys :)

Be a part of the DaniWeb community

We're a friendly, industry-focused community of developers, IT pros, digital marketers, and technology enthusiasts meeting, networking, learning, and sharing knowledge.