2024.04.1转换成2024-04-01 或者2024.4.1转换成2024-04-01
replace("2024.04.01",".","-")
--------
select date_format(replace('2024.4.1','.','-'),'%Y-%m-%d')