SELECT
DATE_FORMAT( CONCAT( date_sub( DATE_FORMAT( now( ), '%Y-%m-%d' ), INTERVAL 1 DAY ), ' 00:00:00' ), '%Y-%m-%d %H:%i:%s' ),
DATE_FORMAT( CONCAT( DATE_FORMAT( now( ), '%Y-%m-%d' ), ' 07:00:00' ), '%Y-%m-%d %H:%i:%s' )
SELECT
DATE_FORMAT( CONCAT( date_sub( DATE_FORMAT( now( ), '%Y-%m-%d' ), INTERVAL 1 DAY ), ' 00:00:00' ), '%Y-%m-%d %H:%i:%s' ),
DATE_FORMAT( CONCAT( DATE_FORMAT( now( ), '%Y-%m-%d' ), ' 07:00:00' ), '%Y-%m-%d %H:%i:%s' )