Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi,
Does anyone knows how to get the difference in Time between two TimeStamp vars?
Ex:
LET vSTART = NOW();
... Process
LET vEND = NOW();
LET vTime = ?
TRACE >>> Executed in: $(vTime);
Thanks in advance
LET vSTART = NOW();
LOAD
rand()
AutoGenerate 10000000;
LET vEND = NOW();
LET vTime = interval(vEND - vSTART, 'hh:mm:ss');
TRACE >>> Executed in: $(vTime);
LOg:
AUTOGENERATE(10000000) 10.000.000 lines fetched
>>> Executed in: 00:00:10
Does Anyone Know it?
I am stuck on it
Thanks
LET vSTART = NOW();
LOAD
rand()
AutoGenerate 10000000;
LET vEND = NOW();
LET vTime = interval(vEND - vSTART, 'hh:mm:ss');
TRACE >>> Executed in: $(vTime);
LOg:
AUTOGENERATE(10000000) 10.000.000 lines fetched
>>> Executed in: 00:00:10
Thank you so much Massimo!
Works perfectly!
At the start of the script i.e. after system variable...
TYPE
let vLastLoadStart = now();
and
at the end of the all script...
TYPE
let vLastLoadEnd = now();
Now you can get Load Time Duration difference by
date(vLastLoadEnd - vLastLoadStart, 'hh:mm:ss')