date month name from date in sql

The DATENAME()  function returns a string, navarchar type, that represents a specified date part of date ,it can be a day , month ,year or time of specific date.

 1,884 total views,  3 views today