title: SQL Server Query: Convert to dd/mm/yyyy from datetime
body: <p>I'm querying a max datetime to bring in the most recent record from another table surrounding a common ID coloumn. I would like to however format this datetime in the standard UK dd/mm/yyyy format. How would I do so? I just cant seem to get this...</p>
  
  <p>Here is my code:</p>
  
  <pre><code>    (SELECT TOP 1 MemberPayments.CoverFinishDay
  FROM
      Members LEFT JOIN MemberPayments
          ON Members.MemberID = MemberPayments.MemberID
          AND CoverFinishDay = (
              SELECT MAX(CoverFinishDay)
              FROM MemberPayments
              WHERE Members.MemberID = MemberPayments.MemberID
          ))
  </code></pre>
  
  <p>CoverFinishDay is stored in standard american datetime. currently the query works, just in the wrong format. I need the output in dd/mm/yyyy</p>