Do not input private or sensitive data. View Qlik Privacy & Cookie Policy.
Skip to main content

Announcements
Qlik Open Lakehouse is Now Generally Available! Discover the key highlights and partner resources here.
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

function to convert time to Millisecond

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

3 Replies
jonathandienst
Partner - Champion III
Partner - Champion III

Hi

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

Logic will get you from a to b. Imagination will take you everywhere. - A Einstein
Not applicable
Author

hi

try according to  this

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

ashfaq_haseeb
Champion III
Champion III

Try this

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

Regards

ASHFAQ