Is that how many seconds are in a 24 hr period? -----Original Message----- From: ADSM: Dist Stor Manager [mailto:[email protected]] On Behalf Of David Ehresman Sent: Monday, May 04, 2015 12:22 PM To: [email protected] 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:[email protected]] On Behalf Of Hanover, Cameron Sent: Monday, May 04, 2015 11:20 AM To: [email protected] 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 [email protected] 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 <[email protected]> > 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
