select (UNIX_TIMESTAMP(CURDATE()-1) + TIME_TO_SEC('11:00:00')) select (UNIX_TIMESTAMP(DATE_ADD(CURDATE(), INTERVAL -7 DAY)) + TIME_TO_SEC('20:00:00'))