On 8 Feb 2007 09:57:16 -0800, johnbao@gmail.com wrote:
> Sorry, the second command should be
>
> SELECT TIME_FORMAT( '45:30:00', '%h:%i' )
> shows
> 09:30
>
>
>
> any idea?

Working as documented:

http://dev.mysql.com/doc/refman/5.0/...functions.html

If the /time/ value contains an hour part that is greater than 23, the
%H and %k hour format specifiers produce a value larger than the usual
range of 0..23. The other hour format specifiers produce the hour value
modulo 12.

--
10. I will not interrogate my enemies in the inner sanctum -- a small hotel
well outside my borders will work just as well.
--Peter Anspach's list of things to do as an Evil Overlord