title: Format of Sql DateTime object
body: <blockquote>
    <p>CAST(IH.InvoiceDate AS date) AS InvoiceDate</p>
  </blockquote>
  
  <p>this returns <strong>2012-03-16</strong> is it possible to format this in the select statement to return <strong>16/03/2012</strong></p>
  
  <p>I'm using Sql Server 2008 R2</p>