topic Re: Dynamic schema DATE conversion to TIMESTAMP to insert ORACLE DB table with Date data type in Talend Studio

Dynamic schema DATE conversion to TIMESTAMP to insert ORACLE DB table with Date data type

Mahesh6 — Fri, 20 Sep 2019 04:08:14 GMT

This is @maheshvardam , i am kind of new to Talend Community version. I have read your article on Dynamic ingestion in ORACLE table . But I am doing same kind of job only with DYNAMIC schema . where I am facing issue while conversion of DATE . I am passing date in format ('YYYY-MM-DD HH:mm:ss') which is in String to the DB column name TIMESTAMP2 with datatype Date (In Dynamic schema conversion is carried out by automatic , But here i have to this kind of conversion explicitly ), but it doesn't allow me to insert in this format , whenever I follow default format i.e (dd-MMM-yy) it allows me. because in my case I want hour (24Hr), minutes ,seconds also So how can I do the conversion ? Please suggest something, I have tried various techniques to fix this.

Re: Dynamic schema DATE conversion to TIMESTAMP to insert ORACLE DB table with Date data type

fdenis — Tue, 24 Sep 2019 13:19:17 GMT

so if you are using dynamic datatype you may not want to change data.
so you may just format our data when extracting (db side).
regards

Re: Dynamic schema DATE conversion to TIMESTAMP to insert ORACLE DB table with Date data type

Mahesh6 — Wed, 25 Sep 2019 02:22:09 GMT

Hi,

Thank you for reply @fdenis.

I have done the same like you have suggested , the I got the Following error. Is there any other way.

Screenshot (10).png