Sum of Difference between two dates (in seconds)

[#1]

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.

[jagan]

HI,

Try like this

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

Hope this helps you.

Regards,

jagan.

[tamilarasu]

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')