Skip to content

Instantly share code, notes, and snippets.

@ralfbecher

ralfbecher/QlikView_Convert_from_Unix_Timestamp.qvs

Last active December 15, 2015 19:58
Show Gist options
  • Star 1 You must be signed in to star a gist
  • Fork 1 You must be signed in to fork a gist
  • Save ralfbecher/5314794 to your computer and use it in GitHub Desktop.
Save ralfbecher/5314794 to your computer and use it in GitHub Desktop.
Download ZIP
Convert from a Unix timestamp to the local time in QlikView
Raw
QlikView_Convert_from_Unix_Timestamp.qvs
// 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