DAYNAME/MONTHNAME(t) 
DAYNAME(t) and MONTHNAME(t) are date functions that supply the weekday or month of the specified day.
Value t: When used in a function, the expression t (date_or_timestamp_expression) must supply a date, a time stamp or an alphanumeric value that matches the current date or time stamp format.
t |
Result of the Function |
|---|---|
DAYNAME(t) or MONTHNAME(t) |
Character string that supplies the name of a weekday (Sunday to Saturday) or month (January to December). |
t is a NULL value |
NULL value |
Example
SQL Tutorial, Functions