MySQL Forums
Forum List  »  Newbie

Re: convert seconds to minuts
Posted by: Hein Vegt
Date: January 10, 2013 02:45PM

Hi Laptop alias,

Thanks for your help
When I use the code you gave I get the desired results.

When I change the time to 892880 the result is: 14:53.88, and that should be: 14.52.88

Apart from that, when I change '88340' to the fieldname I get 00:00:00.

I am not sure how to read your formula, so it's difficult to "think with you".

What can I do to correct this.
Also: is it possible to change : to .
The . is easier to read

Thanks
Hein

Options: ReplyQuote


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