Convert Date format into DD MMM YYYY format in SQL Server

Question

I have a SQL Query, I have to get a value in date format of dd/mm/yyyy

Example: 02/July/2020.

How can I convert it on SQL server?

Answer 1

Using convert() and style 106, you can come close to getting your work done. Then, in the following order, replace the spaces:

SELECT replace(convert(NVARCHAR, getdate(), 106), ' ', '/')