topic Re: Sum of Difference between two dates (in seconds) in QlikView

Sum of Difference between two dates (in seconds)

Thu, 14 Jan 2016 23:40:41 GMT

Hi All,

I am trying to calculate the sum the difference between two dates in seconds. But i am unable to calculate the correct result when i am adding them using sum(). There is a difference when i add it manually and when i use the sum() function.

Expression i am using: sum(interval(END_DATETIME-START_DATETIME,'ss'))

Please suggest how can i resolve this.

Re: Sum of Difference between two dates (in seconds)

jagan — Fri, 15 Jan 2016 01:36:03 GMT

HI,

Try like this

=sum(END_DATETIME-START_DATETIME) * 24 * 60 * 60

Hope this helps you.

Regards,

jagan.

Re: Sum of Difference between two dates (in seconds)

tamilarasu — Fri, 15 Jan 2016 01:43:07 GMT

Hi,

I assume your date format as DD/MM/YYYY hh:mm.

Interval(Timestamp#(END_DATETIME, 'DD/MM/YYYY hh:mm')-Timestamp#(START_DATETIME, 'DD/MM/YYYY hh:mm'),'ss')