Q: Adding decimal hours using DATEADD in Oracle SQL I have the following piece of query which works fine for adding hours to a time value:
to_char(date_add('h', trunc(o.tt_real)::integer, d.pickup_date::timestamp),'HH24:MI') injection_time

In the above tt_real is an integer. Now lets assume I have a tt with decimal hours like this 2.98, 3.55 etc. Can someone suggest an updated version of the above query to incorporate decimal hours ?
An example of the output expected 
10:30 + 2.25 = 12:45

A: rather add minutes instead of hours: (o.tt_real*60)::integer
