Converting Time Format

[rajkumarb]

Hi Experts

Is there a way of converting Epoch Time format to Qlikview

1421426273 -

1421427272 -

Thanks in Advance

[Anonymous]

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 · Accepted solution]

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

[Gysbert_Wassenaar]

Timestamp(25569 +MyEpochTimeFieldHere/86400) as MyTimeStamp

[MarcoWedel]

Hi,

maybe this thread helps:

Date settings

so one solution could be:

= Timestamp(25569 + EpochTimeField / 86400)

hope this helps

regards

Marco

[MarcoWedel]

[rajkumarb]

HI Collin

The Value Your Expression Generated is correct Today's Date