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
********************************
|