Standard date pattern in Dynamic schema

[Anonymous]

Hello,

I'm presently working on Talend Cloud 7.3.1. I have a use case wherein I extract data from Oracle/SQL Server database and load into .csv files. I'm using dynamic type to extract data from tables. 

Issue is even after setting the date as "dd-MM-yyyy", different patterns are being loaded in the files. Is there any additional setting that has to be done for this? Kindly let me know.

Adding the screenshot for reference.

[Anonymous]

Hi
You are using dynamic schema, the data pattern you set on the schema will not be applied to dynamic data type. I think you need to get the column metadata, get the data type and set the date pattern if it is date type, refer to this thread.
https://community.talend.com/t5/Design-and-Development/resolved-Generic-Talend-Job/m-p/92354

Regards
Shong

[Anonymous]

Hi Shong,

Thank you for your reply. 

I could not find solution for my concern in the aforementioned link. Could you kindly help with below concern.

All I need is standard date pattern for dates and standard timestamp pattern for timestamps while using Dynamic schema. 

Thanks in advance.

Daniel.