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