1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23
| --------------
set @pivot = '2018-06-29 15:00:00'
--------------
--------------
select id, time_to_sec(timediff(periode, @pivot)) as diff
from ( select 1 as id, cast('2018-06-29 16:25:00' as datetime) as periode union
select 2 as id, cast('2018-06-29 15:14:00' as datetime) as periode union
select 3 as id, cast('2018-06-29 14:50:00' as datetime) as periode union
select 4 as id, cast('2018-06-29 13:33:00' as datetime) as periode union
select 5 as id, cast('2018-06-29 13:17:00' as datetime) as periode
) as x
having diff between -3600 and +3600
--------------
+----+------+
| id | diff |
+----+------+
| 2 | 840 |
| 3 | -600 |
+----+------+
Appuyez sur une touche pour continuer... |
Partager