Date Time Functions MySQL Tutorial

  1. Home
  2. MySQL Tutorial
  3. Date Time Functions
  4. TIME(expr) extracts the time part of the time or datetime expression expr and returns it as a string
mysql>
mysql> SELECT TIME('2003-12-31 01:02:03');
+-----------------------------+
| TIME('2003-12-31 01:02:03') |
+-----------------------------+
| 01:02:03                    |
+-----------------------------+
1 row in set (0.00 sec)