using datename function for name of month,day

 

select DATENAME(w, GETDATE()) AS ' Day Name'

day name

---------

Wednesday

SELECT DATENAME(m, GETDATE()) AS ' month Name'

month name

---------

may