MySQL Get Day Name from Date Example

Hi Friends,

I am going to explain you example of MySQL get day name from date example. You will learn DAYNAME() Examples – MySQL. I would like get day name from timestamp in MySQL.

This article will give you simple example of DAYNAME() : Full Day name in MySQL. Now, let's see article of how to get day name from date in SQL query.

I will give you simple query to getting data get day name from date from table.

Let's see example here:

Table : users

Solution SQL Query:

SELECT 
    *, 
    DAYNAME(created_at) as day_name 
FROM `users`

Output:

I hope it will help you...