Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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.
This is a date format display issue, I think you need to modify it from DB client tool side.
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
i did what you said but still the same problem
This is a date format display issue, I think you need to modify it from DB client tool side.
yes thats true, thank you so much.
Great, thanks for your feedback!