Springmvc & Sql & Mapper 时间格式化

Java

@DateTimeFormat(pattern = "yyyy-MM-dd HH:mm:ss") //入参
@JsonFormat(timezone = "GMT+8", pattern = "yyyy-MM-dd HH:mm:ss") //出参

Sql

MySql
select date_format('2021-11-16 14:38:25.0','%Y-%m-%d %H:%i:%S')

Mapper查询时间区间

            "and if(#{beginTime} is null,1=1,date_format(d.submission_time,'%Y-%m-%d')>=#{beginTime}) " +
            "and if(#{endTime} is null,1=1,date_format(d.submission_time,'%Y-%m-%d')<=#{endTime}) " +