Beginner Series #2 Clock

Clock shows h hours, m minutes and s seconds after midnight.

Your task is to write a function which returns the time since midnight in milliseconds.

Example:

h = 0
m = 1
s = 1

result = 61000

Input constraints:

• 0 <= h <= 23
• 0 <= m <= 59
• 0 <= s <= 59

 

Solution:

SELECT (h*3600 + m*60 + s)*1000 AS res 
FROM past;

 

Result:

res

61000

3661000

0

3601000

3600000