Skip to content

Instantly share code, notes, and snippets.

@ralfbecher

ralfbecher/QlikView_Convert_into_Unix_Timestamp.qvs

Last active December 15, 2015 19:59
Show Gist options
  • Save ralfbecher/5314845 to your computer and use it in GitHub Desktop.
Save ralfbecher/5314845 to your computer and use it in GitHub Desktop.
Download ZIP
Convert QlikView local time into a Unix timestamp
Raw
QlikView_Convert_into_Unix_Timestamp.qvs
LET t1 = (num(timestamp#('2013-01-11 18:00:00', 'yyyy-mm-dd hh:mm:ss')) - 25569) * 86400;
LET t2 = (num(Now(1) - 25569) * 86400;
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment