Mega Code Archive
TIME type column
mysql>
mysql> CREATE TABLE TIME_TABLE (COLUMN1 TIME);
mysql>
mysql> INSERT INTO TIME_TABLE VALUES ('23:59:59.5912');
Query OK, 1 row affected (0.00 sec)
mysql>
mysql> SELECT COLUMN1 FROM TIME_TABLE;
+----------+
| COLUMN1 |
+----------+
| 23:59:59 |
| 23:59:59 |
+----------+
2 rows in set (0.00 sec)
mysql>