Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi Experts
Is there a way of converting Epoch Time format to Qlikview
1421426273 -
1421427272 -
Thanks in Advance
Assuming that your dates are seconds since 01/01/1970 (Epoch time) I get the following results for date & time conversion.
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' )
Assuming that your dates are seconds since 01/01/1970 (Epoch time) I get the following results for date & time conversion.
Timestamp(25569 +MyEpochTimeFieldHere/86400) as MyTimeStamp
Hi,
maybe this thread helps:
so one solution could be:
= Timestamp(25569 + EpochTimeField / 86400)
hope this helps
regards
Marco
HI Collin
The Value Your Expression Generated is correct Today's Date