title: I need time from a table in SQL Server
body: <pre><code>AS
  
  SELECT     TOP 50 *
  FROM         dbo.Ritten
  
  WHERE     (Status = 0)and (Afgemeld = 0)
  
  ORDER BY CAST(Datum AS date),Tijd
  </code></pre>
  
  <p>Output = 13:30:00.0000000</p>
  
  <p>I need this = 13:30</p>