MySQL 8.0

By using db<>fiddle, you agree to license everything you submit by Creative Commons CC0.
select version();


version()


8.0.36


create table timeseries (id int, object_id int, datetime datetime, sensor1 float default NULL, sensor2 float default NULL);
insert into timeseries values 
(1,175,'2022-03-24 22:01:00',0,0),
(2,175,'2022-03-24 22:02:00',0,0),
(3,175,'2022-03-24 22:03:00',5.5699381666667,81.342836833333),
(4,175,'2022-03-24 22:04:00',75.5668366666667,81.281143),
(5,175,'2022-03-24 22:05:00',5.5615361666667,81.152333333333),
(6,175,'2022-03-24 22:06:00',125.5579035,81.014411166667),
(7,175,'2022-03-24 22:07:00',5.55437,80.871362333333),
(8,175,'2022-03-24 22:08:00',0,0),
(9,175,'2022-03-24 22:09:00',5.5494958333333,80.573867833333),
(10,175,'2022-03-24 22:10:00',5.5588905,80.429978833333),
(11,175,'2022-03-24 22:11:00',135.5732071666667,80.2856845),
(12,175,'2022-03-24 22:12:00',5.6017723333333,80.156250833333),
(13,175,'2022-03-24 22:13:00',5.5661683333333,81.265731166667),
(14,175,'2022-03-24 22:14:00',5.560905,81.1317425),
(15,175,'2022-03-24 22:15:00',5.5569496666667,80.9890755),
(16,175,'2022-03-24 22:16:00',5.5539518333333,80.840372166667),
(17,175,'2022-03-24 22:17:00',5.5490508333333,80.695212833333),
(18,175,'2022-03-24 22:18:00',25.5504593333333,80.541868333333),
(19,175,'2022-03-24 22:19:00',5.5630041666667,80.387255666667),
(20,175,'2022-03-24 22:20:00',5.5828961666667,80.238450333333),
(21,175,'2022-03-24 22:21:00',45.5699381666667,81.342836833333),
(22,175,'2022-03-24 22:22:00',5.562909,81.198894666667),
(23,175,'2022-03-24 22:23:00',5.5592885,81.055038833333),
(24,175,'2022-03-24 22:24:00',5.554888,80.907300333333),
(25,175,'2022-03-24 22:25:00',5.5503573333333,80.762887),
(26,175,'2022-03-24 22:26:00',5.5493505,80.610970666667),
(27,175,'2022-03-24 22:27:00',5.556367,80.4566535),
(28,175,'2022-03-24 22:28:00',5.5706435,80.307021),
(29,175,'2022-03-24 22:29:00',5.6005653333333,80.161287666667),
(30,175,'2022-03-24 22:30:00',5.5659011666667,81.260597333333),
(31,175,'2022-03-24 22:31:00',5.5606363333333,81.1162645),
(32,175,'2022-03-24 22:32:00',5.5564683333333,80.973753),
(33,175,'2022-03-24 22:33:00',5.5536733333333,80.824821),
(34,175,'2022-03-24 22:34:00',55.5490416666667,80.679457833333),
(35,175,'2022-03-24 22:35:00',5.5510683333333,80.525840333333),
(36,175,'2022-03-24 22:36:00',5.5644211666667,80.371161333333),
(37,175,'2022-03-24 22:37:00',5.586449,80.222833333333),
(38,175,'2022-03-24 22:38:00',5.5689038333333,81.322198166667),
(39,175,'2022-03-24 22:39:00',5.5622728333333,81.178228833333),
(40,175,'2022-03-24 22:40:00',5.5586108333333,81.034729166667),
(41,175,'2022-03-24 22:41:00',5.5546986666667,80.891906166667),
(42,175,'2022-03-24 22:42:00',5.549218,80.751597333333),
(43,175,'2022-03-24 22:43:00',5.5494188333333,80.589787166667),
(44,175,'2022-03-24 22:44:00',5.5578781666667,80.4406615),
(45,175,'2022-03-24 22:45:00',5.5723751666667,80.291000333333),
(46,175,'2022-03-24 22:46:00',45.6053015,80.1411425),
(47,175,'2022-03-24 22:47:00',5.5650825,81.245177166667),
(48,175,'2022-03-24 22:48:00',NULL,NULL),
(49,175,'2022-03-24 22:49:00',5.5557831666667,80.953412333333),
(50,175,'2022-03-24 22:50:00',5.5533811666667,80.804116166667),
(51,175,'2022-03-24 22:51:00',5.5491478333333,80.665918),
(52,175,'2022-03-24 22:52:00',5.5520251666667,80.504477333333),
(53,175,'2022-03-24 22:53:00',5.5665315,80.3498265),
(54,175,'2022-03-24 22:54:00',5.5911693333333,80.202129333333),
(55,175,'2022-03-24 22:55:00',15.5678095,81.301650833333),
(56,175,'2022-03-24 22:56:00',45.561704,81.157482166667),
(57,175,'2022-03-24 22:57:00',5.5577405,81.0093435),
(58,175,'2022-03-24 22:58:00',5.554299,80.866211666667),
(59,175,'2022-03-24 22:59:00',NULL,NULL),
(60,175,'2022-03-24 23:00:00',5.5495408333333,80.5632355),
(61,175,'2022-03-24 23:01:00',65.560891,80.4086105),
(62,175,'2022-03-24 23:02:00',5.5782721666667,80.259334),
(63,175,'2022-03-24 23:03:00',5.6123558333333,80.110862166667),
(64,175,'2022-03-24 23:04:00',5.5636185,81.214325333333),
(65,175,'2022-03-24 23:05:00',5.5595933333333,81.065229833333),
(66,175,'2022-03-24 23:06:00',5.5551873333333,80.922694166667),
(67,175,'2022-03-24 23:07:00',85.551549,80.773193333333),
(68,175,'2022-03-24 23:08:00',5.5493123333333,80.621553166667),
(69,175,'2022-03-24 23:09:00',5.5553506666667,80.467293),
(70,175,'2022-03-24 23:10:00',5.5695743333333,80.317732833333),
(71,175,'2022-03-24 23:11:00',5.5993803333333,80.166336),
(72,175,'2022-03-24 23:12:00',5.5663738333333,81.2708725),
(73,175,'2022-03-24 23:13:00',85.5607415,81.126588666667),
(74,175,'2022-03-24 23:14:00',0,0),
(75,175,'2022-03-24 23:15:00',5.5606363333333,81.1162645),
(76,175,'2022-03-24 23:16:00',5.560427,81.085540166667),
(77,175,'2022-03-24 23:17:00',5.5573075,80.9992255),
(78,175,'2022-03-24 23:18:00',5.5548423333333,80.902163166667),
(79,175,'2022-03-24 23:19:00',95.549279,80.752547833333),
(80,175,'2022-03-24 23:20:00',5.5493903333333,80.600384833333),
(81,175,'2022-03-24 23:21:00',5.556852,80.4513275),
(82,175,'2022-03-24 23:22:00',5.5717271666667,80.296324),
(83,175,'2022-03-24 23:23:00',5.6029721666667,80.151211),
(84,175,'2022-03-24 23:24:00',5.5655871666667,81.2554645),
(85,175,'2022-03-24 23:25:00',125.5606013333333,81.105967666667),
(86,175,'2022-03-24 23:26:00',5.555981,80.9636045),
(87,175,'2022-03-24 23:27:00',5.5536385,80.8196325),
(88,175,'2022-03-24 23:28:00',5.5491211666667,80.6689085),
(89,175,'2022-03-24 23:29:00',5.551589,80.5151525),
(90,175,'2022-03-24 23:30:00',5.5655245,80.360583666667),
(91,175,'2022-03-24 23:31:00',5.5887883333333,80.212471333333),
(92,175,'2022-03-24 23:32:00',5.5683191666667,81.3119215),
(93,175,'2022-03-24 23:33:00',5.5619398333333,81.167890166667),
(94,175,'2022-03-24 23:34:00',5.5582271666667,81.024570666667),
(95,175,'2022-03-24 23:35:00',5.5544183333333,80.8765095),
(96,175,'2022-03-24 23:36:00',0,0),
(97,175,'2022-03-24 23:37:00',5.5494958333333,80.573867833333),
(98,175,'2022-03-24 23:38:00',5.5594303333333,80.424644333333),
(99,175,'2022-03-24 23:39:00',5.5759816666667,80.269816166667),
(100,175,'2022-03-24 23:40:00',335.6087826666667,80.126040333333),
(101,175,'2022-03-24 23:41:00',5.5640828333333,81.224608166667),
(102,175,'2022-03-24 23:42:00',5.5603671666667,81.080454333333),
(103,175,'2022-03-24 23:43:00',5.5554798333333,80.938066),
(104,175,'2022-03-24 23:44:00',5.5530805,80.788603166667),
(105,175,'2022-03-24 23:45:00',65.5492185,80.637420166667),
(106,175,'2022-03-24 23:46:00',5.5538676666667,80.483207166667),
(107,175,'2022-03-24 23:47:00',5.5681185,80.333795833333),
(108,175,'2022-03-24 23:48:00',5.5958666666667,80.181567333333),
(109,175,'2022-03-24 23:49:00',5.5671628333333,81.2862655),
(110,175,'2022-03-24 23:50:00',5.5610915,81.136893666667),
(111,175,'2022-03-24 23:51:00',5.5570976666667,80.994157833333),
(112,175,'2022-03-24 23:52:00',85.5541165,80.850724333333),
(113,175,'2022-03-24 23:53:00',95.5490498333333,80.700443333333),
(114,175,'2022-03-24 23:54:00',5.5502788333333,80.5472105),
(115,175,'2022-03-24 23:55:00',5.5624578333333,80.3925915),
(116,175,'2022-03-24 23:56:00',15.5817433333333,80.243665),
(117,175,'2022-03-24 23:57:00',15.5699381666667,81.342836833333),
(118,175,'2022-03-24 23:58:00',15.562909,81.198894666667),
(119,175,'2022-03-24 23:59:00',15.5592885,81.055038833333),
(120,175,'2022-03-25 00:00:00',15.554888,80.907300333333),
(121,175,'2022-03-25 00:01:00',25.5503573333333,80.762887),
(122,175,'2022-03-25 00:02:00',25.5493505,80.610970666667),
(123,175,'2022-03-25 00:03:00',25.5558681666667,80.4619775),
(124,175,'2022-03-25 00:04:00',25.570078,80.3123755),
(125,175,'2022-03-25 00:05:00',5.5982206666667,80.171396666667),
(126,175,'2022-03-25 00:06:00',5.5671628333333,81.2862655),
(127,175,'2022-03-25 00:07:00',35.561368,81.14719),
(128,175,'2022-03-25 00:08:00',35.5575396666667,81.004288166667),
(129,175,'2022-03-25 00:09:00',5.5541413333333,80.855896166667),
(130,175,'2022-03-25 00:10:00',5.5490576666667,80.7108875),
(131,175,'2022-03-25 00:11:00',5.5497558333333,80.5579005),
(132,175,'2022-03-25 00:12:00',5.560891,80.4086105),
(133,175,'2022-03-25 00:13:00',45.5794141666667,80.254101833333),
(134,175,'2022-03-25 00:14:00',45.6123558333333,80.110862166667),
(135,175,'2022-03-25 00:15:00',5.5633431666667,81.209186333333),
(136,175,'2022-03-25 00:16:00',35.5595933333333,81.065229833333),
(137,175,'2022-03-25 00:17:00',5.5551873333333,80.922694166667),
(138,175,'2022-03-25 00:18:00',55.551549,80.773193333333),
(139,175,'2022-03-25 00:19:00',65.5493123333333,80.621553166667),
(140,175,'2022-03-25 00:20:00',NULL,NULL),
(141,175,'2022-03-25 00:21:00',5.5695743333333,80.317732833333),
(142,175,'2022-03-25 00:22:00',5.5993803333333,80.166336);





Records: 142  Duplicates: 0  Warnings: 0


-- QUERY:1 - find starttime and endtime for sensor 1 where value IS NOT NULL

(SELECT   datetime,id,sensor1
     FROM     timeseries
     where datetime between '2021-01-20 22:01:00' and '2024-01-20 00:17:00' limit 1)
    
    Union ALL

    (SELECT   datetime,id,sensor1
     FROM     timeseries
     where datetime between '2021-01-20 22:01:00' and '2024-01-20 00:17:00' ORDER BY datetime DESC limit 1)



datetime
id
sensor1


2022-03-24 22:01:00
1
0

2022-03-25 00:22:00
142
5.59938


(SELECT   datetime,id,sensor2
     FROM     timeseries
     where datetime between '2021-01-20 22:01:00' and '2024-01-20 00:17:00' limit 1)
    
    Union ALL

    (SELECT   datetime,id,sensor2
     FROM     timeseries
     where datetime between '2021-01-20 22:01:00' and '2024-01-20 00:17:00' ORDER BY datetime DESC limit 1)



datetime
id
sensor2


2022-03-24 22:01:00
1
0

2022-03-25 00:22:00
142
80.1663