need help: Mysql Time format problem
This is a discussion on need help: Mysql Time format problem within the MySQL Database forums, part of the Database Forums category; how can I show time 45:30 as 21:30 in Mysql? commnd SELECT TIME_FORMAT( '45:30:00', '%H:%i' ) ...
|
|||||||
| FAQ | Members List | Calendar | Search | Today's Posts | Mark Forums Read |
02-08-2007
|
|||
|
|||
need help: Mysql Time format problem
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. 
|
|
02-08-2007
|
|||
|
|||
|
Re: need help: Mysql Time format problem
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???
|
|
02-08-2007
|
|||
|
|||
|
Re: need help: Mysql Time format problem
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 -
|
Linear Mode
