var sidebar_align = 'right';
var content_container_margin = parseInt('290px');
var sidebar_width = parseInt('270px');
Unanswered: Return date subtraction as fraction of days
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.