MySQL Forums :: Newbie :: convert seconds to minuts


Advanced Search

convert seconds to minuts
Posted by: Hein Vegt ()
Date: January 10, 2013 01:34PM

Hi all

I am very new to mySQL and I am trying to find my way in a database that was made by somebody else.

In this database there is a table (tbResults) with a field called FinalTime.
The contents are the results of speedskating races.
The problem is not the field, but the way the results are stored: each time (mins.secs.hundredths of seconds) is recalculated to 1 number. Apart from that there is an extra 0 added (maybe for future reasons) and can be left out.

My question: how can I get these seconds back to the normal format of mins.secs.hundredths of seconds.

Example:
31410: 31.41
88340: 1.28.34
203300: 3.23.30
892880: 14.52.88
etc

I am thinking about a function that can be used in a query, but don't know how to make that.

Who knows?

Thanks in advance
Hein

PS
Name table: tbResults
Name field: finalTime
Type: int (20)

Options: ReplyQuote


Subject Written By Posted
convert seconds to minuts Hein Vegt 01/10/2013 01:34PM
Re: convert seconds to minuts laptop alias 01/10/2013 02:23PM
Re: convert seconds to minuts Hein Vegt 01/10/2013 02:45PM
Re: convert seconds to minuts laptop alias 01/10/2013 04:55PM
Re: convert seconds to minuts Hein Vegt 01/10/2013 05:42PM
Re: convert seconds to minuts laptop alias 01/11/2013 03:02AM
Re: convert seconds to minuts Rick James 01/12/2013 06:45PM
Re: convert seconds to minuts laptop alias 01/13/2013 02:12AM
Re: convert seconds to minuts Rick James 01/13/2013 11:57AM
Re: convert seconds to minuts laptop alias 01/14/2013 04:30AM
Re: convert seconds to minuts Bjørn Munch 01/11/2013 07:12AM


Sorry, you can't reply to this topic. It has been closed.

Content reproduced on this site is the property of the respective copyright holders. It is not reviewed in advance by Oracle and does not necessarily represent the opinion of Oracle or any other party.