TIME()

Function Description

Extracts the time part of the time or datetime expression expr and returns it as a string. If expr is NULL, NULL is returned.

Function Syntax

> TIME(expr)

Parameter definition

Parameters	Description
expr	Required parameters. The input value in date or datetime format that needs to be extracted

Example

mysql> SELECT TIME('2003-12-31 01:02:03');
+--------------------------------+
| time(2003-12-31 01:02:03) |
+--------------------------------+
| 01:02:03 |
+--------------------------------+
1 row in set (0.01 sec)