EN
MySQL - extract SECOND from DATETIME / TIMESTAMP / TIME
0 points
In this article, we would like to show you how to extract SECOND from DATETIME, TIMESTAMP or TIME in MySQL.
Quick solution:
xxxxxxxxxx1
SELECT SECOND(`column_name`) AS 'alias_name'2
FROM `table_name`;To show how to extract SECOND from DATETIME, TIMESTAMP or TIME, we will use the following table:
Note:
At the end of this article you can find database preparation SQL queries.
In this example, we will select only seconds from every record in event_datetime column from events table.
Query:
xxxxxxxxxx1
SELECT SECOND(`event_datetime`) AS 'seconds'2
FROM `events`;Output:
create_tables.sql file:
xxxxxxxxxx1
CREATE TABLE `events`(2
`id` INT(10) UNSIGNED NOT NULL AUTO_INCREMENT,3
`event_datetime` DATETIME,4
PRIMARY KEY (`id`)5
);insert_data.sql file:
xxxxxxxxxx1
INSERT INTO `events`2
(`event_datetime`) 3
VALUES 4
('2021-01-01 11:41:31'),5
('2021-01-02 12:42:32'),6
('2021-01-03 13:43:33'),7
('2021-01-04 14:44:34'),8
('2021-01-05 15:45:35'),9
('2021-01-06 16:46:36'),10
('2021-01-07 17:47:37'),11
('2021-01-08 18:48:38'),12
('2021-01-09 19:49:39'),13
('2021-01-10 20:50:40');