EN
MySQL - convert date to weekday name
0 points
In this article, we would like to show you how to convert date to the weekday name in MySQL.
Quick solution:
xxxxxxxxxx1
SELECT DAYNAME(date_expression) AS 'alias_name';In this example, we will convert example date ( 2021-01-01 11:41:31 - Friday) to weekday name.
Query:
xxxxxxxxxx1
SELECT DAYNAME('2021-01-01 11:41:31') AS 'day_name';Result:
To show how to convert date to weekday name, we will use the following users table:
Note:
At the end of this article you can find database preparation SQL queries.
In this example, we will convert registration_time column from users table to the day week name using DAYOFWEEK() function.
Query:
xxxxxxxxxx1
SELECT2
`id`, `username`, `registration_time`, 3
DAYNAME(`registration_time`) AS 'day_name'4
FROM `users`;Result:
create_tables.sql file:
xxxxxxxxxx1
CREATE TABLE `users` (2
`id` INT(10) UNSIGNED NOT NULL AUTO_INCREMENT,3
`username` VARCHAR(50) NOT NULL,4
`registration_time` DATETIME NOT NULL,5
PRIMARY KEY (`id`)6
);insert_data.sql file:
xxxxxxxxxx1
INSERT INTO `users`2
(`username`, `registration_time`)3
VALUES4
('Tom', '2021-01-01 11:41:31'),5
('Chris','2021-01-02 11:42:45'),6
('Jack','2021-01-03 15:13:39'),7
('Kim','2021-01-03 15:24:51'),8
('Marco','2021-01-04 22:35:38'),9
('Kate','2021-01-04 22:46:51'),10
('Nam','2021-01-04 22:57:37');