Adding Time and Zone to date

[Mcan1701790226]

Hello,

Talend newbie here...

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).

For example, "01.01.2023" should be changed to "2023-01-01T07:00:00.000+0000"

Thank you for your Help 🙂

[Anonymous]

Hello

If the data type is Date, set the date pattern of this column as below on ​the schema, you will have the expected output.

"yyyy-MM-dd'T'HH:mm:ssZ"

Regards

Shong