Date problems with years over 2040 in tAS400input

[Anonymous]

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!

[Anonymous]

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

[Anonymous · Accepted solution]

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