"select SUM(payMoney) AS payMoney,date_format(FROM_UNIXTIME( `sell_time`),'%Y-%m') AS s_month,interface_company,SUM(awardMoney) AS awardMoney,COUNT(uid) AS uid from sporttery_ticket where status = 2 AND sell_time>=".$var['from_date']." AND sell_time<=".$var['to_date']." group by s_month";
主要是:date_format(FROM_UNIXTIME( `sell_time`),'%Y-%m') sell_time 是表中的时间戳字段
主要是:date_format(FROM_UNIXTIME( `sell_time`),'%Y-%m') sell_time 是表中的时间戳字段