UNIX时间戳 按月分组 按年月分组 按日分组 mysql语句

作者: liluchang 分类: 数据库 发布时间: 2018-04-12 10:31

//1、按月分组:

select month(FROM_UNIXTIME(time)) from table_name group by month(FROM_UNIXTIME(time))

//2、按年月分组:

select DATE_FORMAT(FROM_UNIXTIME(time),”%Y-%m”) from tcm_fund_list group by DATE_FORMAT(FROM_UNIXTIME(time),”%Y-%m”)

//或者:

select FROM_UNIXTIME(time,”%Y-%m”) from tcm_fund_list group by FROM_UNIXTIME(time,”%Y-%m”)

//3、按年月日分组:

select DATE_FORMAT(FROM_UNIXTIME(time),”%Y-%m-%d”) from tcm_fund_list group by DATE_FORMAT(FROM_UNIXTIME(time),”%Y-%m-%d”)

//或者:

select FROM_UNIXTIME(time,”%Y-%m-%d”) from tcm_fund_list group by FROM_UNIXTIME(time,”%Y-%m-%d”)

//其中FROM_UNIXTIME(time,”%Y-%m-%d”)中的time代表UNIX时间戳的字段名称

如果觉得我的文章对您有用,请随意打赏。您的支持将鼓励我继续创作!

标签云