I experiencing problem in executing query on between date command. I got wrong result.
SELECT approval_date FROM itemdetail WHERE approval_date BETWEEN '01/01/2011' AND '15/01/2011'
My Record in Mysql Database:
Anyone could help me. how to get the needed result. sorry am still new in mysql.