convert date format

[a_touti]

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.

[Anonymous]

Hi

'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

[a_touti]

i did what you said but still the same problem

[Anonymous · Accepted solution]

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

[a_touti]

yes thats true, thank you so much.

[Anonymous]

Great, thanks for your feedback!