How to get a particular date format ('dd-MMM-yyyy') in SELECT query SQL Server 2008 R2

Question

I used the CONVERT(data_type(length), expression, style) function for modifying the date format in a SELECT query.

Declare @dt nvarchar(20)

Select @dt = Convert(nvarchar(20), SalesDate, 113) FROM SalesTable

The format I need is 'DD-MMM-YYYY' (eg. '05-Jul-2013') though I could not find the proper style number (eg. 113) for this particular format. 

Can anyone help me with this?

Answer 1

You can try the following code:

Declare @dt NVARCHAR(20)

Select
    @dt = REPLACE(CONVERT(CHAR(15), SalesDate, 106),' ',' - ')
FROM SalesTable

Kick-start your career in SQL with the perfect SQL online course by Intellipaat now!