Time difference between two timestamps

Tue, 12 Nov 2013 15:59:26 GMT

Hi All,

Kindly help me to resolve the difference between two timestamps

Ex:

column 1 : 2013-05-17 22:14:15

column 2: 2013-05-17 22:20:15

Tried out the following option (Mentioned earlier in the community but it didnt work ,returns no value)

Interval(NUM(Date#(finished, 'DD-MM-YYYY hh:mm:ss tt')-num(Date#(started, 'DD-MM-YYYY hh:mm:ss tt'))))

Thanks in advance

Re: Time difference between two timestamps

Clever_Anjos — Tue, 12 Nov 2013 16:04:37 GMT

dont use tt since your using 24h period and adjust you date format

Interval(NUM(Date#(finished, 'YYYY-MM-DD hh:mm:ss')-num(Date#(started, 'YYYY-MM-DD hh:mm:ss'))))