MySQL convert minutes to seconds
I have stored minutes in normal number like 10 (10 minutes) not in any time format.Now i like to convert 开发者_如何学Gominutes to seconds. Is there any functions available in mysql
EX
Result(seconds) = min * 60
600(seconds) = 10 (min) * 60
Thanks in advance
You've already answered your own question: use multiplication.
SELECT foo.min*60 AS sec FROM foo
You could just do something like this:
SELECT (minutes * 60) as 'seconds' FROM table;
精彩评论