How do you arrive at 86400 as the number to divide by?

-----Original Message-----
From: ADSM: Dist Stor Manager [mailto:ADSM-L AT VM.MARIST DOT EDU] On Behalf Of 
Hanover, Cameron
Sent: Monday, May 04, 2015 11:20 AM
To: ADSM-L AT VM.MARIST DOT EDU
Subject: Re: [ADSM-L] sql time

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