You have to Use this...
SELECT YEAR(startdt) AS [Year],MONTH(startdt) AS [Month], DAY(startdt) as [day],Convert(Time,startdt) as [time], COUNT(*) from visit
Group By YEAR(startdt), MONTH(startdt),day(startdt),Convert(Time,startdt)
If you want to get along with Am/Pm u have to use
SELECT RIGHT(CONVERT(VARCHAR(25), GETDATE(), 22),11)
Links:
Time MSDN[
^]