By using db<>fiddle, you agree to license everything you submit by Creative Commons CC0.
| TIME_FORMAT(SEC_TO_TIME(TIME_TO_SEC('24:00')-TIME_TO_SEC(@hour1)), '%H:%i') |
|---|
| 11:30 |
| TIME_FORMAT(SEC_TO_TIME(TIME_TO_SEC('24:00')-TIME_TO_SEC(@hour1)), '%H:%i') |
|---|
| 11:30 |