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

<< Back to main