sql中将字符串转换成日期: ```sql select str_to_date(time_colunms_name,'%Y-%m-%d') time_colunms_name, 其他字段 from dm_sales group by date1;