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)