https://community.qlik.com/t5/Talend-Studio/How-to-convert-the-string-Unix-Timestamp-to-Oracle-timestamp/m-p/2260230#M41430 <P>Please check the below link.</P><P><A href="https://help.talend.com/r/en-US/8.0/tmap/tmap-tlogrow-tfileinputdelimited-tfileinputdelimited-converting-unix-timestamp-to-readable-date-standard-component-create" alt="https://help.talend.com/r/en-US/8.0/tmap/tmap-tlogrow-tfileinputdelimited-tfileinputdelimited-converting-unix-timestamp-to-readable-date-standard-component-create" target="_blank">https://help.talend.com/r/en-US/8.0/tmap/tmap-tlogrow-tfileinputdelimited-tfileinputdelimited-converting-unix-timestamp-to-readable-date-standard-component-create</A></P> Tue, 19 Nov 2019 07:10:11 GMT manodwhb 2019-11-19T07:10:11Z https://community.qlik.com/t5/Talend-Studio/How-to-convert-the-string-Unix-Timestamp-to-Oracle-timestamp/m-p/2260229#M41429 <P>Hi,</P> <P>&nbsp;</P> <P>I have string Sent_time column( which is a Unix timestamp) coming from Rest Api data, i need to convert that string column into oracle timeStamp, that is (YYYY-MM-DD HH24:MI<span class="lia-inline-image-display-wrapper" image-alt="0683p000009M9p6.png"><img src="https://community.qlik.com/t5/image/serverpage/image-id/134116iFBD5D7F21624A744/image-size/large?v=v2&amp;px=999" role="button" title="0683p000009M9p6.png" alt="0683p000009M9p6.png" /></span>S) format. Please find the below image.</P> <P><SPAN class="lia-inline-image-display-wrapper lia-image-align-inline" image-alt="UnixTimestamp.PNG" style="width: 937px;"><span class="lia-inline-image-display-wrapper" image-alt="0683p000009M8Vj.png"><img src="https://community.qlik.com/t5/image/serverpage/image-id/151106i57963639BE6C4376/image-size/large?v=v2&amp;px=999" role="button" title="0683p000009M8Vj.png" alt="0683p000009M8Vj.png" /></span></SPAN></P> <P>&nbsp;</P> <P>I have tried using - TalendDate.parseDate("yyyyMMdd",row1.sent_time)&nbsp; , but it got converted to some other date which is not the actual date.</P> <P>&nbsp;</P> <P>Can anyone help me in this, please note -Sent_time is a String datatype column.</P> <P>&nbsp;</P> <P>Thanks,</P> <P>Abhishek</P> Sat, 16 Nov 2024 04:05:31 GMT https://community.qlik.com/t5/Talend-Studio/How-to-convert-the-string-Unix-Timestamp-to-Oracle-timestamp/m-p/2260229#M41429 Anonymous 2024-11-16T04:05:31Z https://community.qlik.com/t5/Talend-Studio/How-to-convert-the-string-Unix-Timestamp-to-Oracle-timestamp/m-p/2260230#M41430 <P>Please check the below link.</P><P><A href="https://help.talend.com/r/en-US/8.0/tmap/tmap-tlogrow-tfileinputdelimited-tfileinputdelimited-converting-unix-timestamp-to-readable-date-standard-component-create" alt="https://help.talend.com/r/en-US/8.0/tmap/tmap-tlogrow-tfileinputdelimited-tfileinputdelimited-converting-unix-timestamp-to-readable-date-standard-component-create" target="_blank">https://help.talend.com/r/en-US/8.0/tmap/tmap-tlogrow-tfileinputdelimited-tfileinputdelimited-converting-unix-timestamp-to-readable-date-standard-component-create</A></P> Tue, 19 Nov 2019 07:10:11 GMT https://community.qlik.com/t5/Talend-Studio/How-to-convert-the-string-Unix-Timestamp-to-Oracle-timestamp/m-p/2260230#M41430 manodwhb 2019-11-19T07:10:11Z