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.

	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 NULL value	NULL Value

Examples

SQL Tutorial, Functions