Hey @Adiwakar,
Would you be able to share any of the errors you saw? It sounds like we just need to get the data in the right format, both in the DB and from KNIME.
I would recommend establishing the type in DB, then taking a look at the following thread: Convert Date to be read by Oracle
and there is also the underlying workflow on the hub.
Regards,
Wali Khan