Convert integer to timestamp

[Dayna]

Hello,

I'm hoping someone can help me. From my Postgre database, we're getting time values through as a long integer. I need to convert these to a timestamp.

An example being "1537857953942" should actually be Sep 12, 2018 12:05, can someone help, please?

Kind Regards,

Dayna

[m_woolf]

https://community.qlik.com/t5/QlikView-App-Development/Convert-TimeStamp-format/td-p/723107

[Dayna]

Sadly not the same issue, the article you refer to has an integer which is actually the date (20141029122728). Whereas I believe mine is the difference between the actual date, and the Unix timestamp of 01/01/1970.

[m_woolf · Accepted solution]

Try this one:

https://community.qlik.com/t5/New-to-QlikView/13-digit-time-Stamp-to-Date-and-Time/td-p/885177

[Dayna]

Perfect, thank you!

[m_woolf]

Thank Google

[Dayna]

Normally do! 😉