SELECT TIME('2003-12-31 01:02:03.000123'); : TIME « Date Time Functions « MySQL Tutorial






  1. MySQL Tutorial
  2. Date Time Functions
  3. TIME
mysql>
mysql> SELECT TIME('2003-12-31 01:02:03.000123');
+------------------------------------+
| TIME('2003-12-31 01:02:03.000123') |
+------------------------------------+
| 01:02:03.000123                    |
+------------------------------------+
1 row in set (0.00 sec)

mysql>








14.43.TIME
14.43.1.TIME(expr) extracts the time part of the time or datetime expression expr and returns it as a string.
14.43.2.SELECT TIME('2003-12-31 01:02:03.000123');