Extract the entire time value by using the TIME() function: TIME() : Time « Date Time « SQL / MySQL

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