你的时间: `report_time` datetime DEFAULT NULL COMMENT '报道时间',
打印出来:Fri Feb 19 17:32:34 CST 2021
需求:java中将Fri Feb 19 17:32:34 CST 2021时间格式转为yyyy-MM-dd HH:mm:ss时间格式
mapper:
<select id="selectLie" parameterType="java.lang.String" resultType="ProjectReportDo">
select
id,
report_title as reportTitle,
report_media as reportMedia,
date_format(report_time,'%Y-%m-%d %H:%i:%S') as reportTime
from
energy_now_project_report where project_id =#{projectId}