title: SQL Server equivalent of MySQL DATE_FORMAT()
body: <p>Hope we're having a good day and all set for Christmas.</p>
  
  <p>Got a quick question.  I'm converting a MySQL function into SQL Server, I've got most of the function converted except for one part which has the following:</p>
  
  <pre><code>@description = CONCAT(@description, date_format(@INLastUpdated, '%H:%i %d %b %Y'))
  </code></pre>
  
  <p>What I'm trying to do is to basically recreate the <a href="http://dev.mysql.com/doc/refman/5.0/en/date-and-time-functions.html#function_date-format" rel="nofollow">date_format function</a> to format the date in the same way specified, but I'm not sure how to do it.  from what I've seen in the MySQL documentation the format selected would give hour:minute day / short month name / year.</p>
  
  <p>Anyone got any ideas?</p>