MySQL Get Day Name from Date Example

Feb 03, 2022

.

Admin

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...

#MySQL