Articles/SQL

DAYNAME() in MySQL — How It Works

What the MySQL DAYNAME() function does, with an example.

Published October 20, 2026

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

Key points

  • Part of standard SQL functions available in MySQL for working with dates and times

Example

SELECT DAYNAME('2024-01-01');  -- 'Monday'
More SQL articles