get 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.