Query select DATE_FORMAT(FROM_UNIXTIME(time_stamp),'%d'),round(sum(bytes_sent)/1024/1024,2) as mb from apache_logs.access_log where DATE_FORMAT(FROM_UNIXTIME(time_stamp),'%Y%m')='200907' GROUP by DATE_FORMAT(FROM_UNIXTIME(time_stamp),'%d'), Sun Jul 26 14:33:15 2009