Skip to content

Instantly share code, notes, and snippets.

@hagope

hagope/QlikView_Convert_from_Unix_Timestamp.qvs

Forked from ralfbecher/QlikView_Convert_from_Unix_Timestamp.qvs
Last active August 29, 2015 14:24
Show Gist options
  • Star 0 You must be signed in to star a gist
  • Fork 0 You must be signed in to fork a gist
  • Save hagope/21203b5de3cbd819dd10 to your computer and use it in GitHub Desktop.
Save hagope/21203b5de3cbd819dd10 to your computer and use it in GitHub Desktop.
Download ZIP
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>')
// my need
ConvertToLocalTime(Date(MakeDate(1970, 1, 1) + (epoch_ts / 86400)))
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment