use mysql date function to get everything for a single day instead of a range