MySQL 5.7

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

CREATE TABLE tablename (
  `id` INTEGER,
  `s_id` INTEGER,
  `s_date` DATETIME,
  `date_from` DATETIME,
  `date_to` DATETIME
);

INSERT INTO tablename
  (`id`, `s_id`, `s_date`, `date_from`, `date_to`)
VALUES
  ('1', '33', '2021-03-09 13:36:59', '2012-03-12 00:00:00', '2022-01-01 00:00:00'),
  ('2', '33', '2021-03-09 13:36:59', '2018-03-12 00:00:09', '2021-02-28 00:00:00'),
  ('3', '33', '2021-03-09 13:36:59', '2021-03-01 00:00:00', '2021-03-31 00:00:00'),
  ('4', '33', '2021-03-09 13:36:59', '2021-03-07 00:00:00', '2021-03-12 00:00:00'),
  ('5', '33', '2021-03-09 13:36:59', '2021-04-01 00:00:00', '2023-01-01 00:00:00'),
  ('6', '33', '2021-03-15 18:00:00', '2012-03-12 00:00:00', '2022-01-01 00:00:00'),
  ('7', '33', '2021-03-15 18:00:00', '2018-03-12 00:00:09', '2021-02-28 00:00:00'),
  ('8', '33', '2021-03-15 18:00:00', '2021-03-01 00:00:00', '2021-03-31 00:00:00'),
  ('9', '33', '2021-03-15 18:00:00', '2021-03-07 00:00:00', '2021-03-12 00:00:00'),
  ('10', '33', '2021-03-15 18:00:00', '2021-04-01 00:00:00', '2023-01-01 00:00:00');
SELECT *
FROM tablename
ORDER BY ABS(UNIX_TIMESTAMP(s_date) - ((UNIX_TIMESTAMP(date_from) + UNIX_TIMESTAMP(date_to)) / 2))


id
s_id
s_date
date_from
date_to


4
33
2021-03-09 13:36:59
2021-03-07 00:00:00
2021-03-12 00:00:00

8
33
2021-03-15 18:00:00
2021-03-01 00:00:00
2021-03-31 00:00:00

9
33
2021-03-15 18:00:00
2021-03-07 00:00:00
2021-03-12 00:00:00

3
33
2021-03-09 13:36:59
2021-03-01 00:00:00
2021-03-31 00:00:00

10
33
2021-03-15 18:00:00
2021-04-01 00:00:00
2023-01-01 00:00:00

5
33
2021-03-09 13:36:59
2021-04-01 00:00:00
2023-01-01 00:00:00

2
33
2021-03-09 13:36:59
2018-03-12 00:00:09
2021-02-28 00:00:00

7
33
2021-03-15 18:00:00
2018-03-12 00:00:09
2021-02-28 00:00:00

1
33
2021-03-09 13:36:59
2012-03-12 00:00:00
2022-01-01 00:00:00

6
33
2021-03-15 18:00:00
2012-03-12 00:00:00
2022-01-01 00:00:00


SELECT *
FROM tablename
ORDER BY ABS(UNIX_TIMESTAMP(s_date) - ((UNIX_TIMESTAMP(date_from) + UNIX_TIMESTAMP(date_to)) / 2))
LIMIT 2


id
s_id
s_date
date_from
date_to


4
33
2021-03-09 13:36:59
2021-03-07 00:00:00
2021-03-12 00:00:00

8
33
2021-03-15 18:00:00
2021-03-01 00:00:00
2021-03-31 00:00:00

id	s_id	s_date	date_from	date_to
4	33	2021-03-09 13:36:59	2021-03-07 00:00:00	2021-03-12 00:00:00
8	33	2021-03-15 18:00:00	2021-03-01 00:00:00	2021-03-31 00:00:00
9	33	2021-03-15 18:00:00	2021-03-07 00:00:00	2021-03-12 00:00:00
3	33	2021-03-09 13:36:59	2021-03-01 00:00:00	2021-03-31 00:00:00
10	33	2021-03-15 18:00:00	2021-04-01 00:00:00	2023-01-01 00:00:00
5	33	2021-03-09 13:36:59	2021-04-01 00:00:00	2023-01-01 00:00:00
2	33	2021-03-09 13:36:59	2018-03-12 00:00:09	2021-02-28 00:00:00
7	33	2021-03-15 18:00:00	2018-03-12 00:00:09	2021-02-28 00:00:00
1	33	2021-03-09 13:36:59	2012-03-12 00:00:00	2022-01-01 00:00:00
6	33	2021-03-15 18:00:00	2012-03-12 00:00:00	2022-01-01 00:00:00