topic Re: convert date format in Talend Studio

convert date format

a_touti — Fri, 15 Nov 2024 21:59:53 GMT

Hello,

i have a csv file contain dates in this form "yyyy-MM-dd" i wanted to import this file to my database and convert the format to "yyyy/MM/dd" but i didnt find this format on tconverttype and i tried to create a java code but nothing work for me.

any solution please?

thank you in advance.

Re: convert date format

Anonymous — Tue, 14 Mar 2023 08:58:46 GMT

'Read this data as a Date with date pattern "yyyy-MM-dd", then set the date pattern as "yyyy/MM/dd" in the output table on tMap, eg:

tFileInputDelimited--main--tMap--tDBOutput..

Regards

Shong

Re: convert date format

a_touti — Tue, 14 Mar 2023 09:22:35 GMT

i did what you said but still the same problem

Re: convert date format

Anonymous — Tue, 14 Mar 2023 12:31:59 GMT

This is a date format display issue, I think you need to modify it from DB client tool side.

Re: convert date format

a_touti — Wed, 22 Mar 2023 15:17:30 GMT

yes thats true, thank you so much.

Re: convert date format

Anonymous — Thu, 23 Mar 2023 00:02:17 GMT

Great, thanks for your feedback!