How to convert string to date format!

[Anonymous]

Hi Talend Support officer,
Can you tell me how can I convert the string data of "14/09/2001" from MS Access to DB2 date format ("yyyy-mm-dd") as "2001-09-14" by using tMap function in Talend Open Studio, please?
Thanks.
Regards,
KM

[Anonymous]

Thank you xdshi for the support and response

Thanks and regards ,
sriram k

[Anonymous]

I have encountered a similar problem with Screen Update. I resolved it. I attachment has the solution with screenshots.

[Anonymous]

Hi krishnap2w2,

It seems your screenshot is missing. Could you please take a look at it?
Many thanks.

Best regards
Sabrina

[Anonymous]

hello,
iam loading denodo view to mysql through talend 
were as i have two string columns in my source having values like"1-Nov-15",29-06-2015""26/05/2015" now i want to load this values through to talend to mysql.how to load the date were iam getting types of errors.like TYPE MISMATCH
how can i solve this probles

[Srini2]

i was able to resolve this, thank u for ur time

[Anonymous]

Hi manjunath.m,
Is your issue fixed? Could you please show us your component schema setting screenshot into forum?
Best regards
Sabrina

[Anonymous]

Hi Guys,
I have situation.. i have date column with varchar2 datatype in oracle database & i am fetching this table in Talend then that column get converted into string datatype in talend ... i just want to pass values of that column in date datatype into target table with same format... Please see the below is source table.. & tell me solution for this.
Source Table
START_DT         NAME
12-jan-2015       Pankaj
27-Feb-2010      Suraj
         
Thanks in Advance
Shri_Kul1
Talend User.

[Anonymous]

Hi Friend,
I am completely new to this space. I am in learning phase. I have a CSV file which contains date in yyyymmdd format and I want to load this CSV into MS-SQL with yyyy-MM-dd format. I am using tmap. Please help me how can I parse my yyyyMMdd to yyyy-MM-dd.

[Anonymous]

Hi  sandium,
You can use tMap to format your date pattern.
Please take a look at my screenshots. Let us know if it is what you are looking for?
Best regards
Sabrina