While retrieving data from SQL Server, you can always create the format as required by implementing your own logic. Only you need to make changes in the SELECT statement. DATENAME() and DATEPART() function can be used to achieve this.
Check this-
SELECT DATENAME(MONTH,GETDATE())+' '+CAST(DATEPART(DAY,GETDATE()) AS VARCHAR)
OUTPUT:
Result
--------
August 5
If you want the month name to be in lower case then use
LOWER() function as follows-
SELECT LOWER(DATENAME(MONTH,GETDATE()))+' '+CAST(DATEPART(DAY,GETDATE()) AS VARCHAR) AS Result
OUTPUT:
Result
--------
august 5
Hope, it helps :)