Mega Code Archive
%T
mysql>
mysql> SELECT DATE_FORMAT('1997-10-04 22:23:00', '%T');
+------------------------------------------+
| DATE_FORMAT('1997-10-04 22:23:00', '%T') |
+------------------------------------------+
| 22:23:00 |
+------------------------------------------+
1 row in set (0.00 sec)