Solved: Conver Unix Timestamp to standard Qlikview Timesta... - Qlik Community

Anonymous · ‎2016-07-26

Hi ,

I have one column which has UNIX Time stamp.I wish to convert it to standard

Qlikview Timestamp .Please find attached excel

I tried using following code

ConvertToLocalTime(timestamp((25569+(time+3600000)/(1000*24*3600))), 'GMT-01:00') as time,

But it is giveing me values like 1970/01/17 11:21:47 PM

All values are in the range 1970 which is not the actual case.

Any help appreciated .

Thanks,

Nishant Nadkarni

PrashantSangle · ‎2016-07-26

search on community there is so many thread for convert unix timestamp to local timestamp

one of the best thread is

https://community.qlik.com/ideas/2517

Regards

Great dreamer's dreams never fulfilled, they are always transcended.
Please appreciate our Qlik community members by giving Kudos for sharing their time for your query. If your query is answered, please mark the topic as resolved 🙂

View solution in original post

PrashantSangle · ‎2016-07-26

search on community there is so many thread for convert unix timestamp to local timestamp

one of the best thread is

https://community.qlik.com/ideas/2517

Regards

Great dreamer's dreams never fulfilled, they are always transcended.
Please appreciate our Qlik community members by giving Kudos for sharing their time for your query. If your query is answered, please mark the topic as resolved 🙂

Anonymous · ‎2016-07-26

Hi max,

Thanks a lot .It did work .

Regards,

Nishant Nadkarni

Conver Unix Timestamp to standard Qlikview Timestamp