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}) " +