Mysql 根據時間戳按年月日分組統計(做個收藏)

Mysql 根據時間戳按年月日分組統計

-----------------來自小馬哥的故事

create_time時間格式

        SELECT DATE_FORMAT(create_time,'%Y%u') weeks,COUNT(id) COUNT FROM role GROUP BY weeks;

        SELECT DATE_FORMAT(create_time,'%Y%m%d') days,COUNT(id) COUNT FROM role GROUP BY days; 
        SELECT DATE_FORMAT(create_time,'%Y%m') months,COUNT(id) COUNT FROM role GROUP BY months 
        

        create_time時間戳格式

        SELECT FROM_UNIXTIME(create_time,'%Y%u') weeks,COUNT(id) COUNT FROM role GROUP BY weeks; 
        SELECT FROM_UNIXTIME(create_time,'%Y%m%d') days,COUNT(id) COUNT FROM role GROUP BY days; 
        SELECT FROM_UNIXTIME(create_time,'%Y%m') months,COUNT(id) COUNT FROM role GROUP BY months           

複制

本文由 小馬哥 創作，采用 知識共享署名4.0 國際許可協定進行許可

本站文章除注明轉載/出處外，均為本站原創或翻譯，轉載前請務必署名