Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi ,
I used the following formula for getting difference between two datetimes
interval(fabs(interval(date(date#(ENDDATETIME,'DD/MM/YYYY hh:mm:ss'),'DD/MM/YYYY hh:mm:ss')-
date(date#(STARTDATETIME,'DD/MM/YYYY hh:mm:ss'),'DD/MM/YYYY hh:mm:ss'),'ss')),'ss') as Duration.
its working fine
it gives out put like
Duration
02
06
09
But i want to get the out put like
Duration
2
6
9
Please help me.
Thanks,
Try with
interval(fabs(interval(date(date#(ENDDATETIME,'DD/MM/YYYY hh:mm:ss'),'DD/MM/YYYY hh:mm:ss')-
date(date#(STARTDATETIME,'DD/MM/YYYY hh:mm:ss'),'DD/MM/YYYY hh:mm:ss'),'s')),'s') as Duration
let me know
Try with
interval(fabs(interval(date(date#(ENDDATETIME,'DD/MM/YYYY hh:mm:ss'),'DD/MM/YYYY hh:mm:ss')-
date(date#(STARTDATETIME,'DD/MM/YYYY hh:mm:ss'),'DD/MM/YYYY hh:mm:ss'),'s')),'s') as Duration
let me know
Hi saccone,
Its working fine thanks for your help.
Thanks,