Skip to main content
Announcements
Have questions about Qlik Connect? Join us live on April 10th, at 11 AM ET: SIGN UP NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
rajkumarb
Creator II
Creator II

Converting Time Format

Hi Experts

Is there a way of converting Epoch Time format to Qlikview

1421426273 -

1421427272 -

Thanks in Advance

1 Solution

Accepted Solutions
Colin-Albert

Assuming that your dates are seconds since 01/01/1970 (Epoch time) I get the following results for date & time conversion.

Epoch.JPG

View solution in original post

6 Replies
Anonymous
Not applicable

That looks more like a plain text time, rather than Linux Epoch Time.

You could try something like this :

     time ( time# ( '1421426273' , 'hhmmssfff' ) , 'hh:mm:ss fff' )

Colin-Albert

Assuming that your dates are seconds since 01/01/1970 (Epoch time) I get the following results for date & time conversion.

Epoch.JPG

Gysbert_Wassenaar

Timestamp(25569 +MyEpochTimeFieldHere/86400) as MyTimeStamp


talk is cheap, supply exceeds demand
MarcoWedel

Hi,

maybe this thread helps:

Date settings

so one solution could be:

= Timestamp(25569 + EpochTimeField / 86400)

hope this helps

regards

Marco

MarcoWedel

QlikCommunity_Thread_148669_Pic1.JPG

rajkumarb
Creator II
Creator II
Author

HI Collin


The Value Your Expression Generated is correct Today's Date