bugl
bugl
HomeLearnPatternsSearch
HomeLearnPatternsSearch

Loading lesson path

Learn/SQL/SQL References
SQL•SQL References

MySQL DAYNAME() Function

Concept visual

MySQL DAYNAME() Function

Pointer walk
two pointers
leftright102132436485116
left=0
right=6
1
3

Start at both ends

Example

Return the weekday name for a date:

SELECT DAYNAME("2017-06-15");

Definition and Usage

The DAYNAME() function returns the weekday name for a given date.

Syntax

Dayname(

date )

Parameter Values

Parameter

Description date

Required. The date to extract the weekday name from

Technical Details

Works in:

From MySQL 4.0

More Examples

Example

Return the weekday name for a date: SELECT DAYNAME("2017-06-15 09:34:21");

Example

Return the weekday name for the current system date:

SELECT DAYNAME(CURDATE());

Previous

❮ MySQL Functions

Next

Previous

MySQL DAY() Function

Next

MySQL DAYOFMONTH() Function