topic Re: Calculate epoch time / milliseconds in QlikView https://community.qlik.com/t5/QlikView/Calculate-epoch-time-milliseconds/m-p/1251009#M395928 <HTML><HEAD></HEAD><BODY><P>Got it - you can use this:</P><P>=num(date(today(1)))*86400000 - num(date('1/1/1970'))*86400000</P><P></P><P>This will give you epoch time in milliseconds for a specified date. Qlik is storing dates as the number of days passed from 1/1/1900, whereas epoch time starts from 1970. Converting the date to milliseconds, and subtracting 1970, will give you the correct epoch time. </P></BODY></HTML> Tue, 15 Nov 2016 09:18:32 GMT sifatnabil 2016-11-15T09:18:32Z Calculate epoch time / milliseconds https://community.qlik.com/t5/QlikView/Calculate-epoch-time-milliseconds/m-p/1251008#M395927 <HTML><HEAD></HEAD><BODY><P>Hi all,</P><P></P><P>Can we calculate the epoch timestamp or epoch time in milliseconds on QlikView? e.g. if I wanted to convert 14/11/2016 00:00:00 to epoch. The time in milliseconds would be <SPAN style="color: #000000; font-family: 'Open Sans', 'Lucida Grande', sans-serif; font-size: 14px;">1479081600000. Thanks. </SPAN></P></BODY></HTML> Tue, 15 Nov 2016 08:54:05 GMT https://community.qlik.com/t5/QlikView/Calculate-epoch-time-milliseconds/m-p/1251008#M395927 sifatnabil 2016-11-15T08:54:05Z Re: Calculate epoch time / milliseconds https://community.qlik.com/t5/QlikView/Calculate-epoch-time-milliseconds/m-p/1251009#M395928 <HTML><HEAD></HEAD><BODY><P>Got it - you can use this:</P><P>=num(date(today(1)))*86400000 - num(date('1/1/1970'))*86400000</P><P></P><P>This will give you epoch time in milliseconds for a specified date. Qlik is storing dates as the number of days passed from 1/1/1900, whereas epoch time starts from 1970. Converting the date to milliseconds, and subtracting 1970, will give you the correct epoch time. </P></BODY></HTML> Tue, 15 Nov 2016 09:18:32 GMT https://community.qlik.com/t5/QlikView/Calculate-epoch-time-milliseconds/m-p/1251009#M395928 sifatnabil 2016-11-15T09:18:32Z Re: Calculate epoch time / milliseconds https://community.qlik.com/t5/QlikView/Calculate-epoch-time-milliseconds/m-p/1251010#M395929 <HTML><HEAD></HEAD><BODY><P>Hi,</P><P>maybe</P><P><SPAN style="color: #0000ff; font-size: 8pt;"><STRONG style="font-size: 10pt;">Interval</STRONG></SPAN><SPAN style="font-size: 10pt;"><STRONG>(<SPAN style="color: #0000ff;">Date</SPAN>('14/11/2016 09:08:01')-<SPAN style="color: #0000ff;">Date</SPAN></STRONG><STRONG>('01/01/1970'),'ssfff') </STRONG></SPAN></P><P></P><P><SPAN style="font-size: 10pt;"><STRONG>Regards,</STRONG></SPAN></P><P><SPAN style="font-size: 10pt;"><STRONG>Antonio</STRONG></SPAN></P></BODY></HTML> Tue, 15 Nov 2016 09:18:58 GMT https://community.qlik.com/t5/QlikView/Calculate-epoch-time-milliseconds/m-p/1251010#M395929 antoniotiman 2016-11-15T09:18:58Z Re: Calculate epoch time / milliseconds https://community.qlik.com/t5/QlikView/Calculate-epoch-time-milliseconds/m-p/1251011#M395930 <HTML><HEAD></HEAD><BODY><P>you won't need date() with today()</P><P></P><P><SPAN style="color: #3d3d3d; font-family: 'Helvetica Neue', Helvetica, Arial, 'Lucida Grande', sans-serif; font-size: 13px;">=num(today(1))*86400000 - num(date('1/1/1970'))*86400000</SPAN></P></BODY></HTML> Tue, 15 Nov 2016 09:44:13 GMT https://community.qlik.com/t5/QlikView/Calculate-epoch-time-milliseconds/m-p/1251011#M395930 vinieme12 2016-11-15T09:44:13Z