Convert from a Unix timestamp to the local time in QlikView
| // Solution 1: | |
| Timestamp = ConvertToLocalTime(Date(MakeDate(1970, 1, 1) + (<timestamp_field> / 86400)), '<time_zone>') | |
| // Solution 2: | |
| Timestamp = ConvertToLocalTime(Date(25569 + (<timestamp_field> / 86400)), '<time_zone>') |
Sign up for free
to join this conversation on GitHub.
Already have an account?
Sign in to comment