Qlik Community

QlikView Scripting

Discussion Board for collaboration on QlikView Scripting.

kvijay173
New Contributor III

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
Tags (1)
1 Solution

Accepted Solutions

Re: Integer8 to TimeStamp conversion

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
1 Reply

Re: Integer8 to TimeStamp conversion

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
Community Browser