03-Feb-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