title: How do I convert hh:mm:ss to hh:mm in SQL Server?
body: <p>How do I convert hh:mm:ss to hh:mm in SQL Server?</p>
  
  <pre><code>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
  </code></pre>