Qlik Community

QlikView App Development

Discussion Board for collaboration related to QlikView App Development.

Highlighted
dayna_litherlan
Contributor

Convert integer to timestamp

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

1 Solution

Accepted Solutions
Highlighted
mwoolf
Honored Contributor II

Re: Convert integer to timestamp

6 Replies
Highlighted
mwoolf
Honored Contributor II

Re: Convert integer to timestamp

Highlighted
dayna_litherlan
Contributor

Re: Convert integer to timestamp

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.

Highlighted
mwoolf
Honored Contributor II

Re: Convert integer to timestamp

Highlighted
dayna_litherlan
Contributor

Re: Convert integer to timestamp

Perfect, thank you!
Highlighted
mwoolf
Honored Contributor II

Re: Convert integer to timestamp

Thank Google

Highlighted
dayna_litherlan
Contributor

Re: Convert integer to timestamp

Normally do! 😉