Sorry, the second command should be

SELECT TIME_FORMAT( '45:30:00', '%h:%i' )
shows
09:30



any idea?



On Feb 9, 12:32 am, "Captain Paralytic" <paul_laut...@yahoo.com>
wrote:
> On 8 Feb, 16:19, john...@gmail.com wrote:
>
>
>
>
>
> > how can I show time 45:30 as 21:30 in Mysql?
> > commnd
> > SELECT TIME_FORMAT( '45:30:00', '%H:%i' )
> > shows
> > 45:30
>
> > and commnd
> > SELECT TIME_FORMAT( '45:30:00', '%H:%i' )
> > shows
> > 09:30
>
> > both are not 21:30
>
> > How do I do?
>
> > thank you for the help.
>
> I can't see any difference betwen the 2 commands???- Hide quoted text -
>
> - Show quoted text -