[mysql] FROM_UNIXTIME

Select FROM_UNIXTIME(regdate,"%Y-%m-%d") as regdate, count(*) as CNT from LogItemHit Group by FROM_UNIXTIME(regdate,"%Y-%m-%d");