topic Re: converting a PTP (Precision Time Protocol) string into a date and time? in QlikView https://community.qlik.com/t5/QlikView/converting-a-PTP-Precision-Time-Protocol-string-into-a-date-and/m-p/35682#M607990 <HTML><HEAD></HEAD><BODY><P>let me try this</P></BODY></HTML> Thu, 01 Feb 2018 15:02:41 GMT Anonymous 2018-02-01T15:02:41Z converting a PTP (Precision Time Protocol) string into a date and time? https://community.qlik.com/t5/QlikView/converting-a-PTP-Precision-Time-Protocol-string-into-a-date-and/m-p/35678#M607986 <HTML><HEAD></HEAD><BODY><P><SPAN style="font-size: 13.3333px;">Does anyone have experience converting a PTP (Precision Time Protocol) string into a date and time? Here are a few examples of the values that are coming in from the data source. </SPAN></P><P><SPAN style="font-size: 13.3333px;"><BR /></SPAN></P><P><SPAN style="font-size: 13.3333px;">1504720821967</SPAN></P><P><SPAN style="font-size: 13.3333px;">1504720822401</SPAN></P><P><SPAN style="font-size: 13.3333px;">1504720875154</SPAN></P><P><SPAN style="font-size: 13.3333px;">1504720875420</SPAN></P><P><SPAN style="font-size: 13.3333px;">1504720880194</SPAN></P><P><SPAN style="font-size: 13.3333px;">1504720880195</SPAN></P><P><SPAN style="font-size: 13.3333px;">1504720896241</SPAN></P><P><SPAN style="font-size: 13.3333px;">1504720896519</SPAN></P><P><SPAN style="font-size: 13.3333px;">1504720896520</SPAN></P><P><SPAN style="font-size: 13.3333px;">1504720905016</SPAN></P><P><SPAN style="font-size: 13.3333px;">1504720905283</SPAN></P><P><SPAN style="font-size: 13.3333px;">1504721314762</SPAN></P><P><SPAN style="font-size: 13.3333px;">1504721314775</SPAN></P></BODY></HTML> Thu, 01 Feb 2018 14:42:28 GMT https://community.qlik.com/t5/QlikView/converting-a-PTP-Precision-Time-Protocol-string-into-a-date-and/m-p/35678#M607986 Anonymous 2018-02-01T14:42:28Z Re: converting a PTP (Precision Time Protocol) string into a date and time? https://community.qlik.com/t5/QlikView/converting-a-PTP-Precision-Time-Protocol-string-into-a-date-and/m-p/35679#M607987 <HTML><HEAD></HEAD><BODY><P>What date format it should be for <SPAN style="color: #3d3d3d; font-family: 'Helvetica Neue', Helvetica, Arial, 'Lucida Grande', sans-serif; font-size: 13.3333px;"><STRONG>1504720821967</STRONG>??</SPAN></P></BODY></HTML> Thu, 01 Feb 2018 14:50:05 GMT https://community.qlik.com/t5/QlikView/converting-a-PTP-Precision-Time-Protocol-string-into-a-date-and/m-p/35679#M607987 Anil_Babu_Samineni 2018-02-01T14:50:05Z Re: converting a PTP (Precision Time Protocol) string into a date and time? https://community.qlik.com/t5/QlikView/converting-a-PTP-Precision-Time-Protocol-string-into-a-date-and/m-p/35680#M607988 <HTML><HEAD></HEAD><BODY><P>Something like this should work, but you will need to tweak the divisor depending on the precision of those timestamps (I'm assuming 1000, could be higher):</P><P></P><P>Date(Date#('01.01.1970', 'DD.MM.YYYY') + PTPTimestampField/86400/1000) AS Timestamp</P><P></P><P>EDIT: divisor separated for clarity</P></BODY></HTML> Thu, 01 Feb 2018 14:51:35 GMT https://community.qlik.com/t5/QlikView/converting-a-PTP-Precision-Time-Protocol-string-into-a-date-and/m-p/35680#M607988 Miguel_Angel_Baeyens 2018-02-01T14:51:35Z Re: converting a PTP (Precision Time Protocol) string into a date and time? https://community.qlik.com/t5/QlikView/converting-a-PTP-Precision-Time-Protocol-string-into-a-date-and/m-p/35681#M607989 <HTML><HEAD></HEAD><BODY><P>i want in the following format : 'MM/DD/YYYY '</P></BODY></HTML> Thu, 01 Feb 2018 14:59:57 GMT https://community.qlik.com/t5/QlikView/converting-a-PTP-Precision-Time-Protocol-string-into-a-date-and/m-p/35681#M607989 Anonymous 2018-02-01T14:59:57Z Re: converting a PTP (Precision Time Protocol) string into a date and time? https://community.qlik.com/t5/QlikView/converting-a-PTP-Precision-Time-Protocol-string-into-a-date-and/m-p/35682#M607990 <HTML><HEAD></HEAD><BODY><P>let me try this</P></BODY></HTML> Thu, 01 Feb 2018 15:02:41 GMT https://community.qlik.com/t5/QlikView/converting-a-PTP-Precision-Time-Protocol-string-into-a-date-and/m-p/35682#M607990 Anonymous 2018-02-01T15:02:41Z Re: converting a PTP (Precision Time Protocol) string into a date and time? https://community.qlik.com/t5/QlikView/converting-a-PTP-Precision-Time-Protocol-string-into-a-date-and/m-p/35683#M607991 <HTML><HEAD></HEAD><BODY><P>Then specify it even if the script, if you want (applications will be heavier):</P><P></P><P><SPAN style="color: #3d3d3d; font-family: 'Helvetica Neue', Helvetica, Arial, 'Lucida Grande', sans-serif; font-size: 13px;">Date(Date#('01.01.1970', 'DD.MM.YYYY') + PTPTimestampField/86400/1000, 'MM/DD/YYYY hh:mm:ss.fff') AS Timestamp</SPAN></P></BODY></HTML> Thu, 01 Feb 2018 15:02:46 GMT https://community.qlik.com/t5/QlikView/converting-a-PTP-Precision-Time-Protocol-string-into-a-date-and/m-p/35683#M607991 Miguel_Angel_Baeyens 2018-02-01T15:02:46Z Re: converting a PTP (Precision Time Protocol) string into a date and time? https://community.qlik.com/t5/QlikView/converting-a-PTP-Precision-Time-Protocol-string-into-a-date-and/m-p/35684#M607992 <HTML><HEAD></HEAD><BODY><P>That is okay, Please provide output you want to see for that date row if you aware the result <IMG src="https://community.qlik.com/legacyfs/online/emoticons/happy.png" /></P></BODY></HTML> Thu, 01 Feb 2018 15:06:27 GMT https://community.qlik.com/t5/QlikView/converting-a-PTP-Precision-Time-Protocol-string-into-a-date-and/m-p/35684#M607992 Anil_Babu_Samineni 2018-02-01T15:06:27Z Re: converting a PTP (Precision Time Protocol) string into a date and time? https://community.qlik.com/t5/QlikView/converting-a-PTP-Precision-Time-Protocol-string-into-a-date-and/m-p/35685#M607993 <HTML><HEAD></HEAD><BODY><P>Thanks a lot saver of the day</P></BODY></HTML> Thu, 01 Feb 2018 15:16:56 GMT https://community.qlik.com/t5/QlikView/converting-a-PTP-Precision-Time-Protocol-string-into-a-date-and/m-p/35685#M607993 Anonymous 2018-02-01T15:16:56Z