tHMap date format for JSON

Six Stars

tHMap date format for JSON

Hello everyone,

I am using a tHMap to create a JSON object for a webservice. The webservice requires the following date format:

yyyy-MM-dd'T'HH:mm:ss'Z'

I cannot find this specific date format in the Date Formats of the structure. I neither could find a way to define a custom date format. Thus, I am using "Default" as date format at the moment and defined the desired format in the Talend Data Integration schema, which is used as the input for the tHMap. As a result I get the following date format:

yyyy-MM-dd'T'HH:mm:ss.SSS

 

Hence, my question: How can the date format of the tHMap JSON output be changed or customized?

Regards,

Tobi

Nine Stars

Re: tHMap date format for JSON

in tMap you can try this 

 

DateFormat.PNG

Regards,

Veeru Boppudi
Six Stars

Re: tHMap date format for JSON

Hi vboppudi,

thank you for your input. I know how to do it in a tMap, this would be my workaround: Transforming the dates to a string and passing it to the tHMap as string. But from my point of view this is only a workaround and not an ideal solution, as I always have to do a null-safe explicit transformation instead of passing the values through.

Regards.