topic Re: Time difference in millisecond in QlikView

Time difference in millisecond

Tue, 05 May 2015 07:43:49 GMT

Dear Team,

i am using interval function to get difference between two times in second/minutes/ and hour by below mention formaula

1) =interval(Timestamp#('12:00:00.010','hh:mm:ss.fff') - Timestamp#('11:00:00.010','hh:mm:ss.fff'),'s') ANS : 3600

2) =interval(Timestamp#('12:00:00.010','hh:mm:ss.fff') - Timestamp#('11:00:00.010','hh:mm:ss.fff'),'mm') ANS : 60

3) =interval(Timestamp#('12:00:00.010','hh:mm:ss.fff') - Timestamp#('11:00:00.010','hh:mm:ss.fff'),'hh') ANS : 01

i want to get the difference in milliseconds like :

=interval(Timestamp#('12:00:00.010','hh:mm:ss.fff') - Timestamp#('11:00:00.010','hh:mm:ss.fff'),'fff')

Kindly let me know how can we do this.

Regards,

JKV

Gysbert_Wassenaar — Tue, 05 May 2015 07:54:23 GMT

Use sfff as format string:

=interval(Timestamp#('12:00:00.010','hh:mm:ss.fff') - Timestamp#('11:00:00.010','hh:mm:ss.fff'),'sfff')

Tue, 05 May 2015 07:55:41 GMT

See this

MarcoWedel — Tue, 05 May 2015 07:57:07 GMT

(Timestamp#('12:00:00.010','hh:mm:ss.fff') - Timestamp#('11:00:00.010','hh:mm:ss.fff')*86400000

Regards

Marco

MarcoWedel — Tue, 05 May 2015 08:01:10 GMT

(Timestamp#('12:00:00.010','hh:mm:ss.fff') - Timestamp#('11:00:00.010','hh:mm:ss.fff'))*86400000

Tue, 05 May 2015 08:42:11 GMT

Thanks