Extract the entire time value by using the TIME() function: TIME(






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

Extract the entire time value by using the TIME() function: TIME(

    
mysql>
mysql> SELECT TIME('2004-12-31 23:59:59');
+-----------------------------+
| TIME('2004-12-31 23:59:59') |
+-----------------------------+
| 23:59:59                    |
+-----------------------------+
1 row in set (0.00 sec)

mysql>








Related examples in the same category

1.Get Current time
2.Comparing Times to One Another
3.TIME type column
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.