Learning PHP and MySQL
Example 08-15 Using HOUR and MINUTE on a time
SELECT CONCAT_WS(':',hour('4:46:45'),MINUTE('4:46:45'));
Posted by on 08/07 at 05:17 PM
Next entry: Example 08-16 Using DATE_SUB to subtract days
Previous entry: Example 08-14 Using MONTH and MONTHNAME on the purchases table