select str_to_date(DATE_FORMAT(biz_date, '%Y%v'), '%Y%v') 方法拆解 select DATE_FORMAT(now(), '%Y%v'), str_to_date(202346, '%Y%v')