Sql – How to convert hh:mm:ss to hh:mm in SQL Server

sqlsql-serversql-server-2005

How do I convert hh:mm:ss to hh:mm in SQL Server?

select Count(Page) as VisitingCount,Page,CONVERT(VARCHAR(8),Date, 108) from scr_SecuristLog   
where Date between '2009-05-04 00:00:00' and '2009-05-06 14:58'  
and [user] in(select USERNAME             
    from scr_CustomerAuthorities )  
group by Page,Date order by [VisitingCount] asc

Best Solution

CONVERT(VARCHAR(5),Date, 108)-- Gets only HH:mm