Yes, if I did my math right.  I was in the middle of a meeting.

-
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 May 4, 2015, at 12:44 PM, Jeanne Bruno <JBruno AT CENHUD DOT COM> wrote:
> 
> Is that how many seconds are in a 24 hr period?
> 
> -----Original Message-----
> From: ADSM: Dist Stor Manager [mailto:ADSM-L AT VM.MARIST DOT EDU] On Behalf 
> Of David Ehresman
> Sent: Monday, May 04, 2015 12:22 PM
> To: ADSM-L AT VM.MARIST DOT EDU
> Subject: Re: [ADSM-L] sql time
> 
> 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