check this
SELECT COUNT(lead_id) as repetitions ,Convert(Date,created_time)
FROM mg_lead_suggested_listing
GROUP BY Convert(Date,created_time)
HAVING repetitions > 0;
Additionally you can also try
select * from
(
select
Row_number() Over
(Partition by Convert(Date,created_time) Order by
Convert(Date,created_time)) as repetitions
,*
from mg_lead_suggested_listing
) a where repetitions>1