select date_format(end_time,"%Y-%m-%d %H:%i:%s") as end_time from sesame_coupon
date_format(end_time,"%Y-%m-%d %H:%i:%s") as end_time
查询出的时间格式是:
endTime": "1987-07-31 14:12:25"
否则时间格式是:createTime": "2022-04-03T21:03:07.000+00:00"
select date_format(end_time,"%Y-%m-%d %H:%i:%s") as end_time from sesame_coupon
date_format(end_time,"%Y-%m-%d %H:%i:%s") as end_time
查询出的时间格式是:
endTime": "1987-07-31 14:12:25"
否则时间格式是:createTime": "2022-04-03T21:03:07.000+00:00"