BR
asked on
mysql between clause
I create a page to report my orders,
I use two date picker and I list all orders between these dates.
but if I select the very same day, mysql sentence doesn't work.
"SELECT order.odemetarihi FROM order WHERE order.tarih between '$firstdate' and '$seconddate' order by order._key DESC"
normally it works perfectly fine however when $firstdate and $secondate is the same, I was expecting the result of that day, however sql brings nothing...
what do you suggest I should do?
I use two date picker and I list all orders between these dates.
but if I select the very same day, mysql sentence doesn't work.
"SELECT order.odemetarihi FROM order WHERE order.tarih between '$firstdate' and '$seconddate' order by order._key DESC"
normally it works perfectly fine however when $firstdate and $secondate is the same, I was expecting the result of that day, however sql brings nothing...
what do you suggest I should do?
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
ASKER