#Today midnight is same as the next day at 0000hrs #today at 23:59:59 SELECT (CURDATE()+ INTERVAL 1 DAY - INTERVAL 1 SECOND); #return #tomrrow at 0000hrs # You can skip adding the timesamp SELECT TIMEsTAMP(CURDATE()+ INTERVAL 1 DAY);