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)
Subject
Written By
Posted
convert seconds to minuts
January 10, 2013 01:34PM
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.