mysql 实现n小时/n分钟为分组
SELECT
me.value_,
me.times,
DATE_FORMAT(
concat(
date(me.times),
' ',
floor(HOUR (me.times) / 8 ) * 8,
':',
MINUTE(me.times)
),
'%Y-%m-%d %H:%i'
) AS addtime
FROM
main_electric_consumption_table me
GROUP BY
addtime
me.time 为 查询时
原创
2020-07-17 11:18:18 ·
269 阅读 ·
0 评论