title: How to get a particular date format ('dd-MMM-yyyy') in SELECT query SQL Server 2008 R2
body: <p>I am using <code>CONVERT(data_type(length),expression,style)</code> function to change the format of a date in a SELECT query.</p>
  <blockquote>
  <p>Declare @dt nvarchar(20)</p>
  <p>Select @dt = Convert(nvarchar(20), SalesDate, 113)  FROM SalesTable</p>
  </blockquote>
  <p>The format I need is 'dd-MMM-yyyy' (eg. '05-Jul-2013') but I could not find the proper style number (eg. 113) for this particular format. Can any one help me with that please?</p>