topic Re: ConvertToLocalTime Help... in QlikView https://community.qlik.com/t5/QlikView/ConvertToLocalTime-Help/m-p/594598#M220300 <HTML><HEAD></HEAD><BODY><P>As I understand, it is time in seconds after 01/01/1970</P></BODY></HTML> Mon, 05 May 2014 12:37:39 GMT Anonymous 2014-05-05T12:37:39Z ConvertToLocalTime Help... https://community.qlik.com/t5/QlikView/ConvertToLocalTime-Help/m-p/594594#M220296 <HTML><HEAD></HEAD><BODY><P>Hello all,</P><P></P><P></P><P>I want to use ConvertToLocalTime function for UNIX date format in source file.</P><P>My format which is provided is in ex:1394818200 format.</P><P>How to assign parameters for converting UNIX to Date &amp; Time format .</P><P>i have tried following format in text box but not sure whether correct or not:</P><P>=ConvertToLocalTime(timestamp((25569+(max(TIME)+3600000)/(1000*24*3600))), 'GMT-01:00') </P><P></P><P>Thanks in Advance</P><P></P><P></P><P>Thanks &amp; Regards,</P><P>Harshal</P></BODY></HTML> Mon, 05 May 2014 12:06:54 GMT https://community.qlik.com/t5/QlikView/ConvertToLocalTime-Help/m-p/594594#M220296 2014-05-05T12:06:54Z Re: ConvertToLocalTime Help... https://community.qlik.com/t5/QlikView/ConvertToLocalTime-Help/m-p/594595#M220297 <HTML><HEAD></HEAD><BODY><P>I am not very much <SPAN style="line-height: 115%; font-family: 'Calibri','sans-serif'; font-size: 11pt; mso-ascii-theme-font: minor-latin; mso-fareast-font-family: Calibri; mso-fareast-theme-font: minor-latin; mso-hansi-theme-font: minor-latin; mso-bidi-font-family: 'Times New Roman'; mso-bidi-theme-font: minor-bidi; mso-ansi-language: EN-IN; mso-fareast-language: EN-US; mso-bidi-language: AR-SA;">acquainted </SPAN>with Unix. Can you interpret the sample date '1394818200' somehow, may be like MMDDYYYsshh or some other meaningful way?</P></BODY></HTML> Mon, 05 May 2014 12:21:36 GMT https://community.qlik.com/t5/QlikView/ConvertToLocalTime-Help/m-p/594595#M220297 tresB 2014-05-05T12:21:36Z Re: ConvertToLocalTime Help... https://community.qlik.com/t5/QlikView/ConvertToLocalTime-Help/m-p/594596#M220298 <HTML><HEAD></HEAD><BODY><P>Hi tresesco,</P><P></P><P>For ex. 1394818200 <SPAN style="font-size: 10pt; line-height: 1.5em;">conversion is Fri, 14 Mar 2014 17:30:00 GMT.</SPAN></P><P><SPAN style="font-size: 10pt; line-height: 1.5em;">if we use timestamp function or date# then by which way is it possible .</SPAN></P><P></P><P>Thanks,</P><P>Harshal</P></BODY></HTML> Mon, 05 May 2014 12:30:46 GMT https://community.qlik.com/t5/QlikView/ConvertToLocalTime-Help/m-p/594596#M220298 2014-05-05T12:30:46Z Re: ConvertToLocalTime Help... https://community.qlik.com/t5/QlikView/ConvertToLocalTime-Help/m-p/594597#M220299 <HTML><HEAD></HEAD><BODY><P>What is the interpretetion of getting 14 mar 2014 from that number?</P></BODY></HTML> Mon, 05 May 2014 12:34:39 GMT https://community.qlik.com/t5/QlikView/ConvertToLocalTime-Help/m-p/594597#M220299 tresB 2014-05-05T12:34:39Z Re: ConvertToLocalTime Help... https://community.qlik.com/t5/QlikView/ConvertToLocalTime-Help/m-p/594598#M220300 <HTML><HEAD></HEAD><BODY><P>As I understand, it is time in seconds after 01/01/1970</P></BODY></HTML> Mon, 05 May 2014 12:37:39 GMT https://community.qlik.com/t5/QlikView/ConvertToLocalTime-Help/m-p/594598#M220300 Anonymous 2014-05-05T12:37:39Z Re: ConvertToLocalTime Help... https://community.qlik.com/t5/QlikView/ConvertToLocalTime-Help/m-p/594599#M220301 <HTML><HEAD></HEAD><BODY><P>So, the answer is<BR /><SPAN style="color: #0000ff; font-size: 8pt;">timestamp</SPAN><SPAN style="font-size: 8pt;">(</SPAN><SPAN style="color: #0000ff; font-size: 8pt;">makedate</SPAN><SPAN style="font-size: 8pt;">(1970) + 1394818200/86400) </SPAN></P><P></P></BODY></HTML> Mon, 05 May 2014 12:39:12 GMT https://community.qlik.com/t5/QlikView/ConvertToLocalTime-Help/m-p/594599#M220301 Anonymous 2014-05-05T12:39:12Z Re: ConvertToLocalTime Help... https://community.qlik.com/t5/QlikView/ConvertToLocalTime-Help/m-p/594600#M220302 <HTML><HEAD></HEAD><BODY><P>Hi tresesco,</P><P></P><P>With help of this url i found that,</P><P><A href="http://www.onlineconversion.com/unix_time.htm" title="http://www.onlineconversion.com/unix_time.htm">Online Conversion - Unix time conversion</A></P></BODY></HTML> Mon, 05 May 2014 12:44:29 GMT https://community.qlik.com/t5/QlikView/ConvertToLocalTime-Help/m-p/594600#M220302 2014-05-05T12:44:29Z Re: ConvertToLocalTime Help... https://community.qlik.com/t5/QlikView/ConvertToLocalTime-Help/m-p/594601#M220303 <HTML><HEAD></HEAD><BODY><P>If it is so, then try:</P><P>Load</P><P>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; Date(25569+YourNumberField/3600/24) as Date</P></BODY></HTML> Mon, 05 May 2014 12:45:17 GMT https://community.qlik.com/t5/QlikView/ConvertToLocalTime-Help/m-p/594601#M220303 tresB 2014-05-05T12:45:17Z Re: ConvertToLocalTime Help... https://community.qlik.com/t5/QlikView/ConvertToLocalTime-Help/m-p/594602#M220304 <HTML><HEAD></HEAD><BODY><P>Hi tresesco,</P><P></P><P>Thanks a lot for help <IMG src="https://community.qlik.com/legacyfs/online/emoticons/happy.png" />.</P><P>Thanks Michael</P><P></P><P>tresesco please can u give brief for making use of <SPAN style="color: #3d3d3d; font-family: 'Helvetica Neue', Helvetica, Arial, 'Lucida Grande', sans-serif;">25569+YourNumberField/3600/24</SPAN> .</P><P></P><P>Thanks &amp; regards,</P><P>Harshal</P></BODY></HTML> Mon, 05 May 2014 13:16:49 GMT https://community.qlik.com/t5/QlikView/ConvertToLocalTime-Help/m-p/594602#M220304 2014-05-05T13:16:49Z Re: ConvertToLocalTime Help... https://community.qlik.com/t5/QlikView/ConvertToLocalTime-Help/m-p/594603#M220305 <HTML><HEAD></HEAD><BODY><P>Your input is in seconds after the date 01/01/1970. To get day(1-one day) equivalent we need to divide seconds by 60*60*24. The date 01/01/1970 is numericcaly equivalent to <SPAN style="color: #3d3d3d; font-family: 'Helvetica Neue', Helvetica, Arial, 'Lucida Grande', sans-serif;">25569. Hence.... Hope this helps you comprehend.</SPAN></P></BODY></HTML> Mon, 05 May 2014 13:23:37 GMT https://community.qlik.com/t5/QlikView/ConvertToLocalTime-Help/m-p/594603#M220305 tresB 2014-05-05T13:23:37Z