topic Re: function to convert time to Millisecond in QlikView

function to convert time to Millisecond

Mon, 15 Sep 2014 05:31:29 GMT

Dear Team, Is there is any function to convert Time into Millisecond Thanks in Advance Jitendra

jonathandienst — Mon, 15 Sep 2014 05:39:44 GMT

If the source value is a time/date value, then use this to convert MyTime to ms:

=Frac(MyTime) * (24*60*60*1000)

If its an interval and you want to include the days in the interval, use the factor without the Frac:

=MyTime * (24*60*60*1000)

HTH

Jonathan

Mon, 15 Sep 2014 05:56:40 GMT

try according to this

Time(Time#('11:00:00.010','hh:mm:ss.fff'),'sfff')

ashfaq_haseeb — Mon, 15 Sep 2014 06:01:12 GMT

Try this

=(Time#('11:00:01.020','hh:mm:ss.fff')-Time#('11:00:00.010','hh:mm:ss.fff'))*86400000

Regards

ASHFAQ