Would a decimal work instead of a fraction?
This works in TSM7:
select cast((current_timestamp - backup_end)/86400 as decimal(3,2)) from 
filespaces where node_name='MYSUPERNODE'

-
Cameron Hanover
chanover AT umich DOT edu

It is better to be violent, if there is violence in our hearts, than to put on 
the cloak of nonviolence to cover impotence.
--Mahatma Gandhi

> On Apr 30, 2015, at 8:53 AM, David Ehresman <david.ehresman AT LOUISVILLE DOT 
> EDU> wrote:
> 
> I'm having trouble with sql time again.  I am trying to get 
> current_timestamp-backup_end from the filespaces table to display as days and 
> fractions of days.  Any ideas?
> 
> David