topic Re: Convert integer to timestamp in QlikView

Convert integer to timestamp

Dayna — Wed, 15 May 2019 12:49:32 GMT

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

Re: Convert integer to timestamp

m_woolf — Wed, 15 May 2019 13:37:15 GMT

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

Re: Convert integer to timestamp

Dayna — Wed, 15 May 2019 13:40:19 GMT

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.

Re: Convert integer to timestamp

m_woolf — Wed, 15 May 2019 13:45:04 GMT

Try this one:

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

Re: Convert integer to timestamp

Dayna — Wed, 15 May 2019 13:50:37 GMT

Perfect, thank you!

Re: Convert integer to timestamp

m_woolf — Wed, 15 May 2019 13:55:19 GMT

Thank Google

Re: Convert integer to timestamp

Dayna — Wed, 15 May 2019 13:56:31 GMT

Normally do! 😉