This command looks very familiar.
Here's ya go. try this
select with duration
select left(entity,10) as node_name, date(start_time) as date,-
cast(activity as varchar(8)) as activity, time(start_time) as start, -
time(end_time) as end,cast(bytes/1024/1024 as decimal(6,0)) as mb, -
cast(substr(cast(end_time-start_time as char(20)),3,8) as char(8)) as
"duration", -
cast(affected as decimal(7,0)) as files,cast(successful as varchar(3)) as -
success from summary where start_time>=current_timestamp-1 day and -
activity='BACKUP' order by node_name
Sung Y. Lee
"ADSM: Dist Stor Manager" <ADSM-L AT VM.MARIST DOT EDU> wrote on 07/21/2005
07:18:24 AM:
> Hello Everyone!
>
> I have the following select statement and I was wondering how to go about
> getting the duration of the backup? I know that it would be the end_time
-
> start_time, but my syntax must be wrong because it just won't work. Any
> help would be appreciated!
>
> select left(entity,10) as node_name, date(start_time) as date,
> cast(activity as varchar(8)) as activity, time(start_time) as start,
> time(end_time) as end,cast(bytes/1024/1024 as decimal(6,0)) as mb,
> cast(affected as decimal(7,0)) as files,cast(successful as varchar(3)) as
> success from summary where start_time>=current_timestamp-1 day and
> activity='BACKUP' order by node_name
>
> ********************************
> Joni Moyer
> Highmark
> Storage Systems
> Work:(717)302-6603
> Fax:(717)302-5974
> joni.moyer AT highmark DOT com
> ********************************
|