Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi @xdshi ,
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.
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.