Multuply time by hourly rate
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
Subject
Written By
Posted
Multuply time by hourly rate
November 25, 2022 05:30AM
November 25, 2022 12:14PM
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.