sql - 如何转换 hh :mm:ss to hh:mm in SQL Server?

Question

如何在 SQL Server 中将 hh:mm:ss 转换为 hh:mm？

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

Answer 1

CONVERT(VARCHAR(5),Date, 108)-- 仅获取 HH:mm