topic Re: Date problems with years over 2040 in tAS400input in Talend Studio

Date problems with years over 2040 in tAS400input

Anonymous — Tue, 16 Jul 2019 12:38:38 GMT

Hi,

I am trying to select dates using a tAS400input component in Talend 6.3.

In some of these dates, years are over 2040, and they are considered null in the result panel of sql builder of the component.

For example, date '2039-12-31' is fine, but date '2040-01-01' isn't:

I don't have the problem using System i Navigator for example:

Any idea of what can cause the problem?

Thank you in advance for your help!

Re: Date problems with years over 2040 in tAS400input

Anonymous — Mon, 22 Jul 2019 07:50:55 GMT

Hello,

What's the date type are you setting in talend studio? Not sure the date is read correct from the source database, try to add a tLogRow after tAs400Input to print the date on the console.

Best regards

Sabrina

Re: Date problems with years over 2040 in tAS400input

Anonymous — Tue, 23 Jul 2019 08:50:29 GMT

Hi Sabrina,

I'm using date format "dd-MM-yyyy" in Talend.

I don't have problems reading other dates, my AS400 table have more than 100000 lines and dates over 2040 represent 20 lines only.

I managed to resolved the problem by casting the date as timestamp...

Regards,

Alice