topic Re: Converting Time Format in QlikView https://community.qlik.com/t5/QlikView/Converting-Time-Format/m-p/804251#M1036251 <HTML><HEAD></HEAD><BODY><P>HI Collin</P><P></P><P><BR />The Value Your Expression Generated is correct Today's Date</P></BODY></HTML> Fri, 16 Jan 2015 17:09:07 GMT rajkumarb 2015-01-16T17:09:07Z Converting Time Format https://community.qlik.com/t5/QlikView/Converting-Time-Format/m-p/804245#M1036245 <HTML><HEAD></HEAD><BODY><P>Hi Experts </P><P></P><P>Is there a way of converting Epoch Time format to Qlikview</P><P>1421426273 -</P><P>1421427272 - </P><P></P><P>Thanks in Advance</P></BODY></HTML> Fri, 16 Jan 2015 16:40:15 GMT https://community.qlik.com/t5/QlikView/Converting-Time-Format/m-p/804245#M1036245 rajkumarb 2015-01-16T16:40:15Z Re: Converting Time Format https://community.qlik.com/t5/QlikView/Converting-Time-Format/m-p/804246#M1036246 <HTML><HEAD></HEAD><BODY><P>That looks more like a plain text time, rather than Linux Epoch Time.</P><P></P><P>You could try something like this :</P><P></P><P><EM>&nbsp;&nbsp;&nbsp;&nbsp; time ( time# ( '1421426273' , 'hhmmssfff' ) , 'hh:mm:ss fff' )</EM></P></BODY></HTML> Fri, 16 Jan 2015 16:50:21 GMT https://community.qlik.com/t5/QlikView/Converting-Time-Format/m-p/804246#M1036246 Anonymous 2015-01-16T16:50:21Z Re: Converting Time Format https://community.qlik.com/t5/QlikView/Converting-Time-Format/m-p/804247#M1036247 <HTML><HEAD></HEAD><BODY><P>Assuming that your dates are seconds since 01/01/1970 (Epoch time) I get the following results for date &amp; time conversion.</P><P><IMG alt="Epoch.JPG" class="image-1 jive-image" src="https://community.qlik.com/legacyfs/online/75534_Epoch.JPG" style="width: 620px; height: 34px;" /></P></BODY></HTML> Fri, 16 Jan 2015 17:01:56 GMT https://community.qlik.com/t5/QlikView/Converting-Time-Format/m-p/804247#M1036247 Colin-Albert 2015-01-16T17:01:56Z Re: Converting Time Format https://community.qlik.com/t5/QlikView/Converting-Time-Format/m-p/804248#M1036248 <HTML><HEAD></HEAD><BODY><P>Timestamp(25569 +<EM>MyEpochTimeFieldHere</EM>/86400) as MyTimeStamp</P></BODY></HTML> Fri, 16 Jan 2015 17:02:38 GMT https://community.qlik.com/t5/QlikView/Converting-Time-Format/m-p/804248#M1036248 Gysbert_Wassenaar 2015-01-16T17:02:38Z Re: Converting Time Format https://community.qlik.com/t5/QlikView/Converting-Time-Format/m-p/804249#M1036249 <HTML><HEAD></HEAD><BODY><P>Hi,</P><P></P><P>maybe this thread helps:</P><P></P><P><A href="https://community.qlik.com/thread/106210">Date settings</A></P><P></P><P>so one solution could be:</P><P></P><PRE __default_attr="plain" __jive_macro_name="code" class="jive_text_macro jive_macro_code _jivemacro_uid_14214277586522122" jivemacro_uid="_14214277586522122"> <P>= Timestamp(25569 + <SPAN style="color: #3d3d3d; font-family: 'Helvetica Neue', Helvetica, Arial, 'Lucida Grande', sans-serif;">EpochTime</SPAN>Field / 86400)</P> </PRE><P></P><P>hope this helps</P><P></P><P>regards</P><P></P><P>Marco</P></BODY></HTML> Fri, 16 Jan 2015 17:02:51 GMT https://community.qlik.com/t5/QlikView/Converting-Time-Format/m-p/804249#M1036249 MarcoWedel 2015-01-16T17:02:51Z Re: Converting Time Format https://community.qlik.com/t5/QlikView/Converting-Time-Format/m-p/804250#M1036250 <HTML><HEAD></HEAD><BODY><P><IMG alt="QlikCommunity_Thread_148669_Pic1.JPG" class="image-1 jive-image" src="https://community.qlik.com/legacyfs/online/75539_QlikCommunity_Thread_148669_Pic1.JPG" style="height: auto;" /></P></BODY></HTML> Fri, 16 Jan 2015 17:05:20 GMT https://community.qlik.com/t5/QlikView/Converting-Time-Format/m-p/804250#M1036250 MarcoWedel 2015-01-16T17:05:20Z Re: Converting Time Format https://community.qlik.com/t5/QlikView/Converting-Time-Format/m-p/804251#M1036251 <HTML><HEAD></HEAD><BODY><P>HI Collin</P><P></P><P><BR />The Value Your Expression Generated is correct Today's Date</P></BODY></HTML> Fri, 16 Jan 2015 17:09:07 GMT https://community.qlik.com/t5/QlikView/Converting-Time-Format/m-p/804251#M1036251 rajkumarb 2015-01-16T17:09:07Z