...@louisville.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
on
the cloak of nonviolence to cover impotence.
--Mahatma Gandhi
On Apr 30, 2015, at 8:53 AM, David Ehresman david.ehres...@louisville.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
How do you arrive at 86400 as the number to divide by?
-Original Message-
From: ADSM: Dist Stor Manager [mailto:ADSM-L@VM.MARIST.EDU] On Behalf Of
Hanover, Cameron
Sent: Monday, May 04, 2015 11:20 AM
To: ADSM-L@VM.MARIST.EDU
Subject: Re: [ADSM-L] sql time
Would a decimal work instead
Is that how many seconds are in a 24 hr period?
-Original Message-
From: ADSM: Dist Stor Manager [mailto:ADSM-L@VM.MARIST.EDU] On Behalf Of David
Ehresman
Sent: Monday, May 04, 2015 12:22 PM
To: ADSM-L@VM.MARIST.EDU
Subject: Re: [ADSM-L] sql time
How do you arrive at 86400 as the number
...@cenhud.com wrote:
Is that how many seconds are in a 24 hr period?
-Original Message-
From: ADSM: Dist Stor Manager [mailto:ADSM-L@VM.MARIST.EDU] On Behalf Of
David Ehresman
Sent: Monday, May 04, 2015 12:22 PM
To: ADSM-L@VM.MARIST.EDU
Subject: Re: [ADSM-L] sql time
How do you
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
Is there a tms sql time contruct that will allow me to query all the
entries with a start time greater than yesterday at 18:00?
Specifically the query is:
tsm: ULTSMselect entity,cast((cast(sum(bytes) as
decimal(20,3))/1024/1024)+.05
as decimal(10,1)) as Migrated (MB) from summary where
On Fri, 2004-06-11 at 10:01, David E Ehresman wrote:
Is there a tms sql time contruct that will allow me to query all the
entries with a start time greater than yesterday at 18:00?
Specifically the query is:
tsm: ULTSMselect entity,cast((cast(sum(bytes) as
decimal(20,3))/1024/1024)+.05