Search Between Date in Query is not showing the correct Result

  mysql, php

I’m trying to run a query between dates from Mysql Database and my date format saved in data is dd-mm-yyyy

But I am getting the date of the previous year along with the searched data.

Below is my code

SELECT * FROM `msr_bills` WHERE `bill_date` BETWEEN '15-09-2021' AND '23-09-2021';

Source: Ask PHP

LEAVE A COMMENT