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:



DAYNAME(created_at) as day_name

FROM `users`


I hope it will help you...