By using db<>fiddle, you agree to license everything you submit by Creative Commons CC0.
| strftime('%H:%M:%S', '00:45:07.0000') |
|---|
| 00:45:07 |
| substr('00:45:07.0000', 1, 8) |
|---|
| 00:45:07 |
| strftime('%H:%M:%S', '00:45:07.0000') |
|---|
| 00:45:07 |
| substr('00:45:07.0000', 1, 8) |
|---|
| 00:45:07 |