only date in a group by 1

[gmanouvrier]

Hi,
I have to calculate the sum of phones calls by day.
So i wrote these query :
select dt, count(id_ticket) from ticket group by dt

(dt is the date '2003/12/02 10:23:46')
But the whole date is taken into account. i only want the current date without the hours, etc...
How could i suceeded in?

 

[checkai]

select convert(char(10),dt,101) as DT, 
count(id_ticket) 
from ticket 
group by convert(char(10),dt,101)

this should do it.