java.sql.SQLException: Cannot convert value '2017-07' from column 6 to TIMESTAMP.

Cannot convert value '2017-07' from column 6 to TIMESTAMP.; nested exception is java.sql.SQLException: Cannot convert value '2017-07' from column 6 to TIMESTAMP.,

>

SELECT id,agent_id,agent_name,COUNT(carrier_site_id)carrier_Site_Num,city_name, FROM_UNIXTIME(create_time/1000,'%Y-%m') t from gt_report_receive_task WHERE city_id = ? and create_time >= 1498838400000 and create_time <= 1506787199000 and type = 1 GROUP BY agent_id ,t 

也就是在时间转换上报错了,FROM_UNIXTIME(dataTime,format) 的返回值是 一个string类型的，javabean中的时间类型是date类型，将javabean中的date类型变成string类型就好了

FROM_UNIXTIME(data,format)  用于时间戳查询，

DATE_FORMAT(date,format)  用于时间格式