TIME type column : Time « Date Time « SQL / MySQL






  1. SQL / MySQL
  2. Date Time
  3. Time

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>








Related examples in the same category

1.Get Current time
2.Extract the entire time value by using the TIME() function: TIME(
3.Comparing Times to One Another
4.Compare time value
5.Alias column for constant time value
6.Calculates the sum of the two TIME values
7.Return the total working time, using SUM.