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