Convert Date format into DD/MMM/YYYY format in SQL Server

Question

I have a query in SQL, I have to get a date in a format of dd/mm/yy Example: 25/jun/2013. How can I convert it for SQL server? Answer I'm not sure there is an exact match for the format you want. But you can get close with convert() and style 106. Then, replace the spaces:

Accepted Answer

I&#8217;m not sure there is an exact match for the format you want. But you can get close with convert() and style 106. Then, replace the spaces:SELECT replace(convert(NVARCHAR, getdate(), 106), ' ', '/')

Advertisement

Answer