Re: Given Time-In & Time-Out, Get Hours & Minutes That Fall Between 22:00 and 06:00 the FF day

[Peter Brawley]

First, you should avoid using illegal chars like '-' in database object. Until you fix that, you'll need to surround such names with backticks (see the manual on db object names).

select timediff('2021-01-12 17:00:00','2021-01-12 00:00:00');
+-------------------------------------------------------+
| timediff('2021-01-12 17:00:00','2021-01-12 00:00:00') |
+-------------------------------------------------------+
| 17:00:00                                              |
+-------------------------------------------------------+