MySQL时间格式化date_format

1、定义和用法

DATE_FORMAT(date,format)

2、可用的格式

3、实例

select date_format(sum(min_update_at), '%Y-%m-%d %H:%i:%s') min_update_at, date_format(sum(max_update_at), '%Y-%m-%d %H:%i:%s') max_update_at from (select min(update_at) min_update_at, null max_update_at from sku_region_rel where (sku_id, region_id) in ((100121800581394,10423777), (100066357773638,142981621974431), (100121907058695,11153480))) v

min_gmt_modified | max_gmt_modified---------------------------------------------------09-24 20:07:14 | -09-25 12:25:19