I am trying to subtract one datetime from another and return the amount of days in decimal fraction. Like 14.5 days.

One date and time is actually from two different columns so I have to put them together first. So here is what I tried.

(TO_DATE(datr || ' ' || timr, '%m/%d/%Y %H:%M') - assigned_time) as days_old

However the result comes out like this: 14 06:13:41.00000

Any help would be appreciated.