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" <[email protected]> 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 > [EMAIL PROTECTED] > ********************************
