topic Re: Standard date pattern in Dynamic schema in Talend Studio

Standard date pattern in Dynamic schema

Anonymous — Sat, 16 Nov 2024 02:17:12 GMT

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.

Re: Standard date pattern in Dynamic schema

Anonymous — Sun, 31 May 2020 15:23:37 GMT

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

Re: Standard date pattern in Dynamic schema

Anonymous — Sun, 31 May 2020 16:17:46 GMT

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.