an"
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
ote:
>
> 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] s
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
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 of
to put on
the cloak of nonviolence to cover impotence.
--Mahatma Gandhi
> On Apr 30, 2015, at 8:53 AM, David Ehresman
> 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
&
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
#x27;MIGRATION' group by entity
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: ULTSM>sel
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: ULTSM>select entity,cast((cast(sum(bytes) as
decimal(20,3))/1024/1024)+.05
as decimal(10,1)) as "Migrated (MB)" from
