By using db<>fiddle, you agree to license everything you submit by Creative Commons CC0.
version() |
---|
10.4.13-MariaDB |
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 |