What time does it signify?

Question

I created a table with one attribute tt and inserted a value into it.

CREATE TABLE tt(tm TIME);
INSERT INTO tt VALUES(2342342);

On executing the select command the result shown is in the form :

234:23:42

What time does this signify ?

Answer 1

MySQL retrieves and displays TIME values in HH:MM:SS format or HHH:MM:SS format for large hour values. The reason why it can have large values is because it can also represent an interval between two events (which may span over multiple days for example, or even be negative).

H stands for hour, M for minute, and S for second.

So, when you insert 2342342 it becomes 234:23:42 representing 234 hours, 23 minutes, and 42 seconds.

Reference