Mysql to mongo DB conversion for Codeigniter

[cosmos...@exateam.com]

Can any one provide me with the required conversion ???

SELECT SUBSTRING(time,1,16) as time,count(DISTINCT(id)) as hits

FROM `' . TBL_EP_STATS . '`

WHERE time > ' . $this->db->escape($data['current_date'] . ' 00:00:00') . '

GROUP BY SUBSTRING(time,1,16)

[Will Berkeley]

Can you supply us with a sample document? What have you tried? What is the goal of the above SQL statement - what is the useful data will it produce for you?

-Will