This currently gets today which is good
SELECT sum(s.burst) as sum,b.bubble_id,b.bubble_name FROM spends s, bubbles b WHERE s.bid=b.id AND s.burst_date REGEXP DATE_FORMAT(NOW() , '%Y-%m-%d') GROUP BY s.bid ORDER BY sum DESC LIMIT 5
Now how do I get today at 11:45 below
so anything after 11:45 PM would count as the next day.