Skip to main content
Announcements
Have questions about Qlik Connect? Join us live on April 10th, at 11 AM ET: SIGN UP NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
Anonymous
Not applicable

Integer8 to TimeStamp conversion

I am trying to convert the Integer8 value to timestamp using the below thread.

https://www.google.com/url?sa=t&rct=j&q=&esrc=s&source=web&cd=1&cad=rja&uact=8&ved=0ahUKEwiR6_bI4fDN...

But not getting the right value. Really have no idea what is going wrong. Can someone help me please..

My Integer8 field name is accountExpires

Below is the script I am using.. timestamp(left(accountExpires,11)/86400-109205)

Result I am getting is ..

  

accountExpiresNew Time Stamp
922337203685477580710/9/4523 9:52:48 PM
1 Solution

Accepted Solutions
Gysbert_Wassenaar

Next time read the documentation

https://msdn.microsoft.com/en-us/library/ms675098(v=vs.85).aspx:

The date when the account expires. This value represents the number of 100-nanosecond intervals since January 1, 1601 (UTC). A value of 0 or 0x7FFFFFFFFFFFFFFF (9223372036854775807) indicates that the account never expires.


talk is cheap, supply exceeds demand

View solution in original post

1 Reply
Gysbert_Wassenaar

Next time read the documentation

https://msdn.microsoft.com/en-us/library/ms675098(v=vs.85).aspx:

The date when the account expires. This value represents the number of 100-nanosecond intervals since January 1, 1601 (UTC). A value of 0 or 0x7FFFFFFFFFFFFFFF (9223372036854775807) indicates that the account never expires.


talk is cheap, supply exceeds demand