By using db<>fiddle, you agree to license everything you submit by Creative Commons CC0.
| version() |
|---|
| 8.0.20 |
| TIME_FORMAT("0:1:38:096", "%H:%i:%s:%f") |
|---|
| 00:01:38:000000 |
| TIME_FORMAT("1:38", "%i:%s") |
|---|
| 38:00 |
| TIME_FORMAT("1:38:096", "%i:%s:%f") |
|---|
| null |
| STR_TO_DATE("1:38:096", "%i:%s:%f") | TIME_FORMAT("1:38:096", "%i:%s:%f") |
|---|---|
| 00:01:38.096000 | null |