Mysql TIME
From w3cyberlearnings
Contents |
MySQL TIME Function
This function returns time from date or datetime expression.
Syntax TIME
- expre: date or datetime expression
TIME(expre);
Example 1
mysql> SELECT TIME('2012-05-22 12:05:55');
+-----------------------------+
| TIME('2012-05-22 12:05:55') |
+-----------------------------+
| 12:05:55 |
+-----------------------------+
1 row in set (0.00 sec)
