https://community.qlik.com/t5/Talend-Studio/Adding-Time-and-Zone-to-date/m-p/2365333#M128949 <P>Hello </P><P>If the data type is Date, set the date pattern of this column as below on ​the schema, you will have the expected output.</P><P>"yyyy-MM-dd'T'HH:mm:ssZ"</P><P>&nbsp;</P><P>Regards</P><P>Shong</P> Mon, 18 Dec 2023 02:57:27 GMT Anonymous 2023-12-18T02:57:27Z https://community.qlik.com/t5/Talend-Studio/Adding-Time-and-Zone-to-date/m-p/2365332#M128948 <P>Hello,</P><P></P><P></P><P>Talend newbie here...</P><P>I have the following problem: How do I add hours. Minutes and seconds as well as time zone (format: "yyyy-MM-dd'T'HH:mm:ss'.000Z'" ) to a date field (format: dd.MM.yyy).</P><P></P><P></P><P>For example, "01.01.2023" should be changed to "2023-01-01T07:00:00.000+0000"</P><P></P><P></P><P></P><P></P><P>Thank you for your Help <span class="lia-unicode-emoji" title=":slightly_smiling_face:">🙂</span></P><P></P><P></P> Tue, 05 Dec 2023 15:42:14 GMT https://community.qlik.com/t5/Talend-Studio/Adding-Time-and-Zone-to-date/m-p/2365332#M128948 Mcan1701790226 2023-12-05T15:42:14Z https://community.qlik.com/t5/Talend-Studio/Adding-Time-and-Zone-to-date/m-p/2365333#M128949 <P>Hello </P><P>If the data type is Date, set the date pattern of this column as below on ​the schema, you will have the expected output.</P><P>"yyyy-MM-dd'T'HH:mm:ssZ"</P><P>&nbsp;</P><P>Regards</P><P>Shong</P> Mon, 18 Dec 2023 02:57:27 GMT https://community.qlik.com/t5/Talend-Studio/Adding-Time-and-Zone-to-date/m-p/2365333#M128949 Anonymous 2023-12-18T02:57:27Z