topic Re: Oracle Dates not being read correctly in Talend Studio

Oracle Dates not being read correctly

Dobby1 — Fri, 30 Nov 2018 20:47:38 GMT

My Oracle table has a date column with a date of 25-FEB-81. It is being read by a tDBInput Oracle as 0981-03-02 00:00:00.0. Other dates such as 04-MAR-98 are read correctly as 1998-03-04 00:00:00.0. The Type and DB Type are set as Date in the Schema and Date in the tMap.

I am using Talend Open Studio for Data Integration Version: 7.0.1

Is there an issue with Oracle dates before a particular period?

Re: Oracle Dates not being read correctly

Anonymous — Sat, 01 Dec 2018 00:27:58 GMT

Hello

Could you please show us your component setting screenshots on forum which will be helpful for us to address your issue?

Best regards

Sabrina

Re: Oracle Dates not being read correctly

Dobby1 — Sat, 01 Dec 2018 01:11:25 GMT

TraceComponentI have attached screen shots as requested.

Re: Oracle Dates not being read correctly

Anonymous — Mon, 03 Dec 2018 04:13:38 GMT

Hi,

Could you please share the screenshot of your schema (where you have configured the column details)? Also please share the format you have given in the schema.

One additional thing I would recommend is to query the underlying database using Oracle SQL Assistant or any other utility to see the actual data in database.

Warm Regards,

Nikhil Thampi

Re: Oracle Dates not being read correctly

Dobby1 — Mon, 03 Dec 2018 15:05:36 GMT

SchemaResult from SQL Developer Query

Re: Oracle Dates not being read correctly

Anonymous — Mon, 03 Dec 2018 15:10:19 GMT

Hi,

Could you please change the SQL assistant year format to YYYY. and display the results again.

My prediction is that it will show 0981.

If the answer has helped you, could you please mark the topic as resolved? Kudos are also welcome 🙂

Warm Regards,

Nikhil Thampi

Re: Oracle Dates not being read correctly

Dobby1 — Mon, 03 Dec 2018 15:55:37 GMT

You are correct. It does show 0981. I'll have to look at fixing this from the Oracle end or transform the date before storing to my target database. Thank you.

Re: Oracle Dates not being read correctly

Anonymous — Mon, 03 Dec 2018 15:59:54 GMT

@Dobby

Thanks for the reply.

Could you please mark my previous post as answer to the post so that the topic can be closed?

Warm Regards,

Nikhil Thampi