title: Convert DATE_FORMAT to SQL Server function
body: <p>Have migrated my database from mysql to SQL Server. When I run my query I get the error: </p>
  
  <blockquote>
    <p>'DATE_FORMAT' is not a recognized built-in function name.</p>
  </blockquote>
  
  <p>This is the query, where I am trying to convert the date as it's saved in the database 2014/03/03 to 03/03/2014 (D-M-Y).</p>
  
  <p>This is the query:</p>
  
  <pre><code>DATE_FORMAT(routines.date, '%d/%m/%Y') as Dato
  </code></pre>