Hi Maurice
I figure how to get a correct output with the function: timestampdiff
(parameter 4 is for minutes)
sum(timestampdiff( 4, char(end_time-start_time))) as elapsed,
here output:
NODENAME Date (D/M/Y) TIME ELAPSED Examined Obj
Affected ObjFailed Ob
substr(cast(end_time-start_time as varchar(17)),3,8) as elapsed, -
Replace this part with: end_time-start_time as elapsed, -
so you can see what part of the output you need to cut.
Regards,
Maurice van 't Loo
TSM Freelancer
2010/11/13 Robert Ouzen :
> Hi
>
> I try to figure how to calculate t
Hi
I try to figure how to calculate the elapse time of my backups in version6 , my
old script V5 give me the correct output in the V6 the format is incorrect.
The script below:
Select substr( entity,1,15) as nodename, -
date(start_time) as "Date (D/M/Y)", -
time(start_time) as time, -
