topic Re: [resolved] Type mismatch: cannot convert string to date. in Talend Studio

[resolved] Type mismatch: cannot convert string to date.

Anonymous — Sat, 16 Nov 2024 10:48:54 GMT

Hi,
I have a scenario in which data present in emp_dept.csv file should be split and inserted into two respective tables(EMP,DEPT)
Actually there is a field DOB declared as string in input schema(.csv file) but in EMP table the same column declared as date.
I tried with tMap TalendDate.formatting function also but getting the following error.
Type mismatch: cannot convert string to date.
Can somebody help me to overcome the situation.
Thanks
Babu Chokka

Re: [resolved] Type mismatch: cannot convert string to date.

Anonymous — Thu, 11 Feb 2016 08:22:34 GMT

Hi
Have you tried to use formatDate function?
TalendDate.formatDate("yyyy-MM-dd HH:mm:ss",myDate)

Re: [resolved] Type mismatch: cannot convert string to date.

Anonymous — Tue, 16 Feb 2016 10:16:27 GMT

Hi, I have tried using the TalendDate.formatDate function but still getting the type mismatch error.
I have two tables EMP and DEPT, I am trying to insert records from .CSV file to these tables using tMap.
- EMP contains columns EMP_NO, NAME, DOB, DESIGNATION and DEPT_NO
- DEPT contains columns DEPT_NO and DEPT_NAME
While inserting giving the below error since DOB is string in .CSV file but the DOB column declared as Date in EMP table.
Note :- Due to Date datatype only getting the error, if we make the DOB column as varchar2 then there is no issue.

Re: [resolved] Type mismatch: cannot convert string to date.

Anonymous — Tue, 16 Feb 2016 10:17:49 GMT

sorry forgot to keep the error i.e, Type mismatch :cannot convert from string to date

Re: [resolved] Type mismatch: cannot convert string to date.

Anonymous — Wed, 17 Feb 2016 09:46:01 GMT

Hi Daniel,
Thanks for your guidance, it worked for me when I tried with TalendDate.parseDate("dd/MM/yyyy",row1.DOB(input schema column name))
Regards
Babu Chokka

Re: [resolved] Type mismatch: cannot convert string to date.

Anonymous — Wed, 15 Nov 2017 08:56:55 GMT

Hi, in this format

TalendDate.parseDate("dd/MM/yyyy",row1.DOB(input schema column name))

can you please what to substitute in place of input schema