title: What data should I use for this query to return results?
body: <p>This is my SQL query. I have data in my tables for this query. But this query doesn't return any results. </p>
  
  <pre><code>Select Prod_Batch_ID,tbl_product.product_name, Quantity,DATE_FORMAT(Production_Date, '%W, %D %M %Y') from tbl_production,tbl_product where tbl_production.Product_ID  = tbl_product.Product_ID and (Production_Date between STR_TO_DATE('2010-01-01 00:00:00.000','%m/%d/%Y')and DATE_ADD(STR_TO_DATE('2010-12-12 00:00:00.000','%m/%d/%Y'), INTERVAL 1 DAY))
  </code></pre>
  
  <p>The Production_Date column in the table is of timestamp type. Is converting to date using str_to_date the problem here?</p>