MySQL Forums
Forum List  »  Newbie

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.

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

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

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

Options: ReplyQuote

Written By
convert seconds to minuts
January 10, 2013 01:34PM
January 10, 2013 02:23PM
January 10, 2013 02:45PM
January 10, 2013 04:55PM
January 10, 2013 05:42PM
January 11, 2013 03:02AM
January 12, 2013 06:45PM
January 13, 2013 02:12AM
January 13, 2013 11:57AM
January 14, 2013 04:30AM
January 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.