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.

DAYNAME(t)/MONTHNAME(t)
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