By using db<>fiddle, you agree to license everything you submit by Creative Commons CC0.
5 rows affected
| HOURS | MINUTES | TIME | AS_STRING |
|---|---|---|---|
| -1 | -30 | -000000000 01:30:00.000000000 | -01:30 |
| 0 | 0 | +000000000 00:00:00.000000000 | 00:00 |
| 1 | 15 | +000000000 01:15:00.000000000 | 01:15 |
| 1 | 30 | +000000000 01:30:00.000000000 | 01:30 |
| 26 | 29 | +000000001 02:29:00.000000000 | 26:29 |