topic Problem with PARSE DATE in Talend Studio

topic Problem with PARSE DATE in Talend Studio https://community.qlik.com/t5/Talend-Studio/Problem-with-PARSE-DATE/m-p/2360388#M124986 <P>Hi everyone,</P><P>I have a problem to parse a date from millisecond to 'YYYY-MM-DD hh:mm. From tFileProperties i get mtime and i bring it into tmap. How can i trasform this time 1694694720000 into date format YYYY-MM-DD hh:mm? I have mtime_string too but it return Thu Sep 14 14:32:00 CEST 2023 and i can't trasform in my format date. Someone can help me?</P><P>thank you</P><P><span class="lia-inline-image-display-wrapper" image-alt="0695b00000of31sAAA.png"><img src="https://community.qlik.com/t5/image/serverpage/image-id/132586i703B7C313327CCEF/image-size/large?v=v2&px=999" role="button" title="0695b00000of31sAAA.png" alt="0695b00000of31sAAA.png" /></span></P> Fri, 15 Nov 2024 21:23:03 GMT lcupito 2024-11-15T21:23:03Z Problem with PARSE DATE https://community.qlik.com/t5/Talend-Studio/Problem-with-PARSE-DATE/m-p/2360388#M124986 <P>Hi everyone,</P><P>I have a problem to parse a date from millisecond to 'YYYY-MM-DD hh:mm. From tFileProperties i get mtime and i bring it into tmap. How can i trasform this time 1694694720000 into date format YYYY-MM-DD hh:mm? I have mtime_string too but it return Thu Sep 14 14:32:00 CEST 2023 and i can't trasform in my format date. Someone can help me?</P><P>thank you</P><P><span class="lia-inline-image-display-wrapper" image-alt="0695b00000of31sAAA.png"><img src="https://community.qlik.com/t5/image/serverpage/image-id/132586i703B7C313327CCEF/image-size/large?v=v2&px=999" role="button" title="0695b00000of31sAAA.png" alt="0695b00000of31sAAA.png" /></span></P> Fri, 15 Nov 2024 21:23:03 GMT https://community.qlik.com/t5/Talend-Studio/Problem-with-PARSE-DATE/m-p/2360388#M124986 lcupito 2024-11-15T21:23:03Z Re: Problem with PARSE DATE https://community.qlik.com/t5/Talend-Studio/Problem-with-PARSE-DATE/m-p/2360389#M124987 <P>Hi lcupito, </P><P>you can easily get:</P><UL><LI>a <B>Date </B>variable from <B>mtime </B>(in this case remember to set the date pattern in the output schema)</LI><LI>or a <B>String </B>variable from <B>mtime_string</B>.</LI></UL><P> </P><P>Depending on what you need, try creating one of these 2 variables in your tMap:</P><P> </P><UL><LI><B>myDate </B>-> <I>new java.util.Date((long)(row1.mtime*1000)/1000) </I></LI><LI><B>myString </B>-> <I>TalendDate.formatDate("yyyy-MM-dd HH:mm",TalendDate.parseDate("EEE MMM dd HH:mm:ss zzz yyyy",row3.mtime_string)) </I></LI></UL><P> </P><P><span class="lia-inline-image-display-wrapper" image-alt="0695b00000of4L0AAI.jpg"><img src="https://community.qlik.com/t5/image/serverpage/image-id/135630i3B3FBDF2A7B37124/image-size/large?v=v2&px=999" role="button" title="0695b00000of4L0AAI.jpg" alt="0695b00000of4L0AAI.jpg" /></span> </P><P><span class="lia-inline-image-display-wrapper" image-alt="0695b00000of4LFAAY.jpg"><img src="https://community.qlik.com/t5/image/serverpage/image-id/140794i99B83911B83993E6/image-size/large?v=v2&px=999" role="button" title="0695b00000of4LFAAY.jpg" alt="0695b00000of4LFAAY.jpg" /></span> </P><P>Regards, </P><P>Fabio</P> Mon, 25 Sep 2023 14:43:45 GMT https://community.qlik.com/t5/Talend-Studio/Problem-with-PARSE-DATE/m-p/2360389#M124987 Fabio_Caimi 2023-09-25T14:43:45Z