sql1 = "SELECT id, CAST(start_time AS CHAR),CAST(end_time AS CHAR),time_type,adm_level AS date FROM s_wnt_20 WHERE id = 1111110 AND stat_date = '2020-10-20' AND time_type = 12"
说明:CAST(start_time AS CHAR) 就是我们需要转化的时间,start_time就是我们数据表的列名
个人笔记mysql语句如下(无用勿喷)sql1 = "SELECT id, CAST(start_time AS CHAR),CAST(end_time AS CHAR),time_type,adm_level AS date FROM s_warn_highvalue_stat_2020 WHERE project_id = 3 AND stat_date = '2020-10-20' AND time_type = 7"说明:CAST(start_time AS CHAR) 就是我们需要转化的时间