Difference between two datetimes

[Anonymous]

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,

[alexandros17 · Accepted solution]

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

[Anonymous]

Hi saccone,

Its working fine thanks for your help.

Thanks,