The **`MONTHNAME()`** function returns the name of the month from a date sent as a parameter. 

Figure 1 shows a visual representation of the `MONTHNAME()` function and the month numbers.

# Syntax
```sql
MONTHNAME(date)
```
# Parameter
The `MONTHNAME()` function takes the date as a parameter. 
> Dates must be in the format YYYY-MM-DD, or else this function returns `NULL`.

# Return value
The `MONTHNAME()` function returns the name of the month from a date sent as a parameter.  
>It returns `NULL` if the month part of the date is *equal to 0 or greater than 12*.


# Example
The following example shows how we can get the month from the admission dates of students using the `MONTHNAME()` function.




Students

SELECT *, MONTHNAME(studentAdmissionDate) as MonthName
from Students;

What is MONTHNAME() in SQL?

The MONTHNAME() function returns the name of the month from a given date in SQL format.

*Student ID*	*Student Name*	*Student Admission Date*
1	David	2000-07-14
2	Luiss	2002-08-15
3	Harvey	2005-04-19
4	Lucy	2010-01-27
5	Andrew	2011-10-03