I want to do a select between dates, where the first date starts with time 00:00:00 and the second date ends at 23:59:59. The date field needs to remain dynamic; I don't want to hardcode the date everytime. Is there a means to take the current date and set a static time - aka 00:00:01? Here is what I don't want - "SELECT * FROM $table WHERE (`timestamp` BETWEEN DATE_SUB(now(), INTERVAL 2 DAY) AND DATE_SUB(now(), INTERVAL 1 DAY)) ORDER BY Hits DESC"
This only gives me a mid-range comparison; since i'm using now ().