MySQL Forums
Forum List  »  Newbie

Multuply time by hourly rate
Posted by: Pedro Camara
Date: November 25, 2022 05:30AM

Hello all,

I have this table with time for each row. The time format is hh:mm.
I have rows with all kind of time, 6:30, 5:10, 5:00, 6:42 etc and I have to multiply it by the hourly rate.

Could you please help me?

I think I have to, first convert this time column into a number so I can multiply it with the hourlyRate, right? How do i do this in mysql?

Thank you all in advance

Options: ReplyQuote


Subject
Written By
Posted
Multuply time by hourly rate
November 25, 2022 05:30AM


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.