Incorrect result of date less than 1970 in database

[RA6]

Hello guys,

I am encountering a date issue while trying to insert data into a table => (snowflake database => data type is DATE in DB)

As you can see below, It is happening to all dates less than 1970; except 01/01/yyyy

The issue occurs when i use date type; however when i use string type, i don't have the issue and all the dates are appearing correctly.

it is a simple job, rightly to test this date issue. 

 

Can you someone advise please?

Thank you.

Best regards,

RA

[Anonymous]

@Rohit Aftab​ , what is the data type in snowflake db? I did a testing with Date type, it has the same data as original data.

[RA6]

Hello @Shicong Hong​,

The snowflake db is of date type:

 

 

 

As you can see, everything is of type date.

The weird thing is that, dates above "01/01/1980" are displaying well in the database.

Another weird thing is that if i make it to String type, it works :

 

[RA6]

Hello @Shicong Hong​ 

Here is another remark that i have made yesterday.

We are currently using Talend Cloud Real_Time Big Data Platform and all the tests that i have done till now, it was with with one.

Tested in both localhost and server-side => Incorrect dates for both

 

However i have tried the same test with the open source version => Talend Open Studio Data Integration and i was unable to reproduce the error; all the dates were inserted correctly either with date type or string.

I really don't know what is causing this issue now.

Regards,

RA

[Anonymous]

What is the version of Talend Open Studio for Data Integration? You are using an very old version 7.1.1, i can't remember if it was a bug? I am using Talend Cloud Data Fabric 8.0.1 and I can't reproduce the issue.

[RA6]

Hello @Shicong Hong​ ,

it is the TOS_DI-20181026_1147-V7.1.1