How do I change this time duration 1.80 into this 2.20 in my DB2 query results
I have a table that gives me time spent in the form of 1.80 meaning 1 hour and 80 min
I have a query that pulls that data but I want the results of my query to take that 1.80 and convert it into 2.20 meaning 2 hours and 20 min.
what should that look like in my query?