Do not input private or sensitive data. View Qlik Privacy & Cookie Policy.
Skip to main content

Announcements
Discover how organizations are unlocking new revenue streams: Watch here
cancel
Showing results for 
Search instead for 
Did you mean: 
BNP
Contributor
Contributor

Date to string and String to Date

Hi Team,

 

I'm new to this talend tool.can you help this

I have data in Date Column like "DD - MM-YYYY"(16-08-2012) and "DD- Sep-YY"(16-Sep-2012)  in CSV file.

How need to convert String tmap

 

Thanks in advance

Labels (2)
1 Solution

Accepted Solutions
Anonymous
Not applicable

Hi
convert string to Date:
TalendDate.parseDateLocale("dd-MMM-yyyy",row1.columnName,"en");

convert Date to string:
TalendDate.formatDateLocale("dd-MMM-yyyy",row1.columnName,"en")

Please try and let me know if you have any questions.
Regards
Shong

View solution in original post

1 Reply
Anonymous
Not applicable

Hi
convert string to Date:
TalendDate.parseDateLocale("dd-MMM-yyyy",row1.columnName,"en");

convert Date to string:
TalendDate.formatDateLocale("dd-MMM-yyyy",row1.columnName,"en")

Please try and let me know if you have any questions.
Regards
Shong