Using only MySQL, how can I make a selection based on dates in "MM/DD/YYYY" format working with a column that is formated as Unix Timestamp?
This query produces the results I desire:
SELECT * FROM `sales` WHERE `sale_time` > 1409529600 AND `sale_time` < 1414799999
HOwever, instead of providing the dates in a Unix Timestamp format, I want to provide them as: "09/01/2014" and "1409529600".
The first date should be calculated on the first second of that date and the second date should be calculated on the last second of that date.