MySQL 5.7

By using db<>fiddle, you agree to license everything you submit by Creative Commons CC0.

select version();


version()


5.7.35


CREATE TABLE prec -- precipitation and NOT rain! My dad was a meterologist
(
  id INT NOT NULL,
  rain FLOAT NOT NULL,
  ts   TIMESTAMP NOT NULL
);
INSERT INTO prec VALUES

(0, 3.5, '2021-10-04 11:55:00'),
(1, 4.2, '2021-10-04 12:00:00'),

--
-- starts again after the hour
--


(2 ,  0.2, '2021-10-04 12:05:00'),
(3 ,  0.6, '2021-10-04 12:10:00'),
(4 ,  0.9, '2021-10-04 12:15:00'),
(5 ,  0.9, '2021-10-04 12:20:00'),
(6 ,  1.4, '2021-10-04 12:25:00'),
(12,  2.5, '2021-10-04 12:55:00'),

(13, 2.6, '2021-10-04 13:00:00'),


--
-- starts again **FROM** the hour!
--

(14,  0.1, '2021-10-04 13:05:00'),
(15,  0.6, '2021-10-04 13:10:00'),
(24,  1.5, '2021-10-04 13:55:00'),
(25,  1.8, '2021-10-04 14:00:00');

SELECT 
  rain, ts, DATE(ts), HOUR(ts), MINUTE(ts)
FROM
  prec
WHERE MINUTE(ts) = 55;
  


rain
ts
DATE(ts)
HOUR(ts)
MINUTE(ts)


3.5
2021-10-04 11:55:00
2021-10-04
11
55

2.5
2021-10-04 12:55:00
2021-10-04
12
55

1.5
2021-10-04 13:55:00
2021-10-04
13
55


SELECT
  rain, ts, DATE(ts), HOUR(ts), MINUTE(ts)
FROM
  prec 
WHERE MINUTE(ts) = 0;


rain
ts
DATE(ts)
HOUR(ts)
MINUTE(ts)


4.2
2021-10-04 12:00:00
2021-10-04
12
0

2.6
2021-10-04 13:00:00
2021-10-04
13
0

1.8
2021-10-04 14:00:00
2021-10-04
14
0

rain	ts	DATE(ts)	HOUR(ts)	MINUTE(ts)
3.5	2021-10-04 11:55:00	2021-10-04	11	55
2.5	2021-10-04 12:55:00	2021-10-04	12	55
1.5	2021-10-04 13:55:00	2021-10-04	13	55

rain	ts	DATE(ts)	HOUR(ts)
4.2	2021-10-04 12:00:00	2021-10-04	12
2.6	2021-10-04 13:00:00	2021-10-04	13
1.8	2021-10-04 14:00:00	2021-10-04	14