SELECT DATE_FORMAT( deteline, "%Y-%m-%d %H" ) , COUNT( * ) FROM test
GROUP BY DATE_FORMAT( deteline, "%Y-%m-%d %H" )
查询某天:
deteline, "%Y-%m-%d
某时:
deteline, "%Y-%m-%d %H"
注意:本文归作者所有,未经作者允许,不得转载
阿里云新老用户最新优惠