select DATE_FORMAT(date_sub(NOW(),interval 1 day),'%Y-%m-%d 00:00:00') as hahah,DATE_FORMAT(date_sub(NOW(),interval 1 day),'%Y-%m-%d 23:59:59') as zzs
select DATE_FORMAT(date_sub(NOW(),interval 1 day),'%Y-%m-%d 00:00:00') as hahah,DATE_FORMAT(date_sub(NOW(),interval 1 day),'%Y-%m-%d 23:59:59') as zzs