Transfer data between 2 Tables having issues with Date conversion from string to Date datatype

Question

Hi team,

I need an assistance from you guys, Could you please help ?!

I'm doing a simple data transfer between 2 Oracle tables( Both the DB's  are on different servers, not the same DB )

I have a table called A in the 1st Oracle DB and, Table B in DB2.

Table A has a date column with the string datatype and, Table B has the date column with the datatype DATE.

I get the following error msg shown in the screenshot below. I'm not sure if the error msg is due to the incorrect format of the date in the source DB.

Answer 1

This can be solved making use of the following function in Oracle.

to_date(columnname, 'dd/mm/yyyy')

While trying to fetch data from Oracle instead of default query try using the following query.

select to_date(columnname, 'yyyymmdd') from table.

Please make sure that the format of the date should be exactly the same as that in String format else this will not work.