title: SQL Server 2005 Date Formatting [DD-Mon-YY hh:mm:ss]
body: <p>I have datetimes stored in a table in SQL Server 2005 in the format of:</p>
  
  <pre><code> 2012-04-16 00:00:00.000
  </code></pre>
  
  <p>I need to get date in the format of 16-Apr-2012 00:00:00 in my query result.</p>
  
  <p>What is the best method of doing this?</p>