EN
MySQL - convert date to month name
0 points
In this article, we would like to show you how to convert date to the month name in MySQL.
Quick solution:
xxxxxxxxxx
1
SELECT MONTHNAME(date_expression) AS 'alias_name';
In this example, we will convert example date ( 2021-01-01 11:41:31
- January) to month name.
Query:
xxxxxxxxxx
1
SELECT MONTHNAME('2021-01-01 11:41:31') AS 'month_name';
Result:
To show how to convert date to month 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 month name using MONTHNAME()
function.
Query:
xxxxxxxxxx
1
SELECT
2
`id`, `username`, `registration_time`,
3
MONTHNAME(`registration_time`) AS 'month_name'
4
FROM `users`;
Result:
create_tables.sql
file:
xxxxxxxxxx
1
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:
xxxxxxxxxx
1
INSERT INTO `users`
2
(`username`, `registration_time`)
3
VALUES
4
('Tom', '2021-01-01 11:41:31'),
5
('Chris','2021-02-02 11:42:45'),
6
('Jack','2021-03-03 15:13:39'),
7
('Kim','2021-04-03 15:24:51'),
8
('Marco','2021-05-04 22:35:38'),
9
('Kate','2021-06-04 22:46:51'),
10
('Nam','2021-07-04 22:57:37');