I have this selected column :
convert(TT.horas, Time) AS TimeTT,
this column can have values like 08:00:00, 04:30:00, 05:50;00 etc, and I need to apply an hourly rate for each row, for example 40€.
My question is what is the best format for that column to accomplish this. Before the convert, this column is text.
I've tried unix_timestamp, time_to_sec and DateTimeToNumberDemo. None of this worked.
Can you guys help me?
Thanks a lot in advance