Oracle Dates not being read correctly

[Dobby1]

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?

[Anonymous]

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

[Dobby1]

TraceComponentI have attached screen shots as requested.

[Anonymous]

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

[Dobby1]

SchemaResult from SQL Developer Query

[Anonymous · Accepted solution]

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

[Dobby1]

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.

[Anonymous]

@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