Since SQL Server 2012, there is an inbuilt function called FORMAT() is there for this kind of requirement.
Example:
SELECT FORMAT(GETDATE(), 'D')
Reference-
SQL Server's FORMAT() function[
^]
For SQL Server version earlier than 2012, you can create your own work around like
SELECT DATENAME(WEEKDAY,GETDATE())+', '+DATENAME(MONTH,GETDATE())+' '+DATENAME(DD,GETDATE())+', '+DATENAME(YEAR,GETDATE())
You can create an user defined function for this for reuse of the code. In case you need help on that, please let me know.
Hope that helps :)