mysql #unixtime quirk unixtime(123) = 01:02:03¶
mysql> select from_unixtime(0);+---------------------+| from_unixtime(0) |+---------------------+| 1970-01-01 01:00:00 |+---------------------+1 row in set (0.00 sec)mysql> select from_unixtime(123);+---------------------+| from_unixtime(123) |+---------------------+| 1970-01-01 01:02:03 |+---------------------+1 row in set (0.01 sec)