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