title: how to format a SQL Server date according to a specific pattern?
body: <p>In MySQL there's the DATE_FORMAT() function that allows to represent a given date value according to the specified pattern.</p>
  
  <p>Is there something like it in MS SQL Server?</p>
  
  <p>The statement I'm trying to format is:</p>
  
  <p><code>SELECT TOP 1 CONVERT(VARCHAR(20), ot.Timestamp,110) AS 'TS' FROM ot, cl WHERE ot.CompID = cl.CompID;</code></p>
  
  <p>Which outputs as MM-DD-YYYY. There are other styles, but I haven't found one that suits me.</p>
  
  <p>I need something that outputs as DD/MM/YYYY HH:MM. Where HH is 24 hour format.</p>
  
  <p>How can I best do this?</p>