title: FORMAT function not working in sql server 2008 R2
body: <pre><code>DECLARE @d DATETIME = '01/01/2011';
  SELECT FORMAT ( @d, 'd', 'en-US' ) AS US_Result;
  </code></pre>
  
  <p>I am using above code in SQL Server 2008 R2 but it is encountering an error:</p>
  
  <blockquote>
    <p>'FORMAT' is not a recognized built-in function name.</p>
  </blockquote>
  
  <p>How can I use <code>FORMAT</code> function?</p>