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]

Hi any one can say for this............
I know how to use job compare and with the help of job compare we will compare two two different jobs or two version of the same job is possible.
But i can't understand what is the use of job compare in talend enterprise edition (what is the use of comparison)

[bkar81]

Hi Mahadevan,
Please post this in a separate topic instead of posting it here (since this is not related to the topic started for)

[Anonymous]

Thanks karthi............
ok i will create this question as a new topic but if you know the answer than kindly share with me............

1. with the help of job compare just ,we will identify the difference between two jobs
2. But my doubt is what is use of job compare

[bkar81]

As you said, job compare is used to identify the differences between 2 jobs.
Its similar to code compare.

[Anonymous]

hi,
i have date format (dd-mm-yyyy HH:MM) string as datatype. but now i want the same format datatype as Date.
so i tried with this expression TalendDate.parseDate("dd-MM-yyyy HH:MM",row1.columnname)
After i entered the expression its not showing any result for me. It shows same thing string only. Can you please help for me.

[Anonymous]

if you share output result, and your input date it will help us to understand what is the issue, however, i am giving below function which convert your date and then apply another format to see the difference.
i am doubting you are getting right result in Date datatype not a string, but if you are using tLogRow to print the output or java function to print on console it will look like string. please check once.

TalendDate.formatDate("yyyy-MM-dd", TalendDate.parseDate("dd-MM-yyyy HH:MM",row1.columnname));

[Anonymous]

I have a date object, and for NULL date i want to store blank in excel file. Please suggest any way

[Anonymous]

hi team, 
I am getting the following error could you please help me in solving the problem
 
i need the syntax for (oldata.end_dt!="9999-12-31") ?  TalendDate.getDate("yyyy-MM-dd")  : oldata.end_dt  in tmap   

[Anonymous]

sorry team after several attempts, i got the output the actual syntax is TalendDate.formatDate("yyyy-MM-dd",oldata.end_dt).equals("9999-12-31")?  Var.var1 :TalendDate.formatDate("yyyy-MM-dd",oldata.end_dt)    

[Anonymous]

Hi sriramk,
Thanks for sharing your solution with us.
Best regards
Sabrina