The **`DAYNAME()`** function returns the weekday name when given a date sent as a parameter. 

Figure 1 shows a visual representation of the `DAYNAME()` function.

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

# Return value
The `DAYNAME()` function returns the weekday name from a date sent as a parameter.  
> This function returns `NULL` if the date is incorrect, i.e., the date is 0 or greater than 31.

# Code
The following example shows how we can isolate the weekday name from the admission dates of students using the `DAYNAME()` function.




Students

SELECT *, DAYNAME(studentAdmissionDate) as DayName
from Students;

What is DAYNAME() in SQL?

DAYNAME() returns the weekday name for a given date in YYYY-MM-DD format, returning NULL if incorrect.

*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