topic Date format with 6 digits nano seconds in Talend Studio https://community.qlik.com/t5/Talend-Studio/Date-format-with-6-digits-nano-seconds/m-p/2354935#M120795 <P>Hi,</P><P></P><P></P><P>I have input string "2021-07-14-19.55.49.107000" , I just want to convert from string to Date datatype.</P><P></P><P></P><P>Currently i tried with tMap component using TalendDate.parseDate("yyyy-MM-dd-HH.mm.ss.SSSSSS", "</P><P>2021-07-14-19.55.49.107000"</P>)&nbsp;<P></P><P></P><P><B>Output is : </B>2021-07-14-19.57.36.000000</P><P></P><P></P><P><B>Expected Output:</B> </P><P>2021-07-14-19.55.49.107000</P><P></P><P></P><P>Please help me on this issue.</P><P>Thanks in advance.</P><P></P><P></P><P>Regards,</P><P>Ganesh.R</P> Thu, 15 Jul 2021 18:15:38 GMT ganeshK 2021-07-15T18:15:38Z Date format with 6 digits nano seconds https://community.qlik.com/t5/Talend-Studio/Date-format-with-6-digits-nano-seconds/m-p/2354935#M120795 <P>Hi,</P><P></P><P></P><P>I have input string "2021-07-14-19.55.49.107000" , I just want to convert from string to Date datatype.</P><P></P><P></P><P>Currently i tried with tMap component using TalendDate.parseDate("yyyy-MM-dd-HH.mm.ss.SSSSSS", "</P><P>2021-07-14-19.55.49.107000"</P>)&nbsp;<P></P><P></P><P><B>Output is : </B>2021-07-14-19.57.36.000000</P><P></P><P></P><P><B>Expected Output:</B> </P><P>2021-07-14-19.55.49.107000</P><P></P><P></P><P>Please help me on this issue.</P><P>Thanks in advance.</P><P></P><P></P><P>Regards,</P><P>Ganesh.R</P> Thu, 15 Jul 2021 18:15:38 GMT https://community.qlik.com/t5/Talend-Studio/Date-format-with-6-digits-nano-seconds/m-p/2354935#M120795 ganeshK 2021-07-15T18:15:38Z Re: Date format with 6 digits nano seconds https://community.qlik.com/t5/Talend-Studio/Date-format-with-6-digits-nano-seconds/m-p/2354936#M120796 <P>Hello,</P><P>Here is a KB article about: <A href="https://community.talend.com/s/article/How-to-fetch-data-that-uses-the-date-format-in-microseconds-yyyy-MM-dd-HH-mm-ss-SSSSSS-jIG4z" alt="https://community.talend.com/s/article/How-to-fetch-data-that-uses-the-date-format-in-microseconds-yyyy-MM-dd-HH-mm-ss-SSSSSS-jIG4z" target="_blank">https://community.talend.com/s/article/How-to-fetch-data-that-uses-the-date-format-in-microseconds-yyyy-MM-dd-HH-mm-ss-SSSSSS-jIG4z</A></P><P>Hope it helps.</P><P>Best regards</P><P>Sabrina</P> Fri, 16 Jul 2021 06:50:40 GMT https://community.qlik.com/t5/Talend-Studio/Date-format-with-6-digits-nano-seconds/m-p/2354936#M120796 Anonymous 2021-07-16T06:50:40Z