Returns a character string containing the data source/specific name of the day (for example, Sunday through Saturday).

 

Example:

SELECT DAYNAME({d '2001-09-31'}) returns Thursday