Learning PHP and MySQL
Example 08-18 Using DATE_FORMAT with a string to place colons between the segments
SELECT DATE_FORMAT('2006-12-24 09:09:23', '%h:%i:%s');
Posted by on 08/07 at 05:18 PM
Next entry: Example 08-17 Using the minus operator on a date
Previous entry: Example 08-16 Using DATE_SUB to subtract days