topic Re: Inconsistent Date field while fetching from csv to postgresSQL !!! in Talend Studio

Inconsistent Date field while fetching from csv to postgresSQL !!!

gervit14 — Thu, 11 Jul 2019 10:53:39 GMT

Hi Team,

I am using postgreSQL and trying to load a column from one table to another in the same db.

My source column is of VARCHAR type having date values. I am parsing this date and storing it in the target column as "yyyy-MM-dd" format in 'Date' datatype.

Problem: For some record the value is coming fine but for some records the date field is coming as one day before the actual date.

Conversion from string to date is as :

row5.seniority_date==null || row5.seniority_date.isEmpty() || row5.seniority_date.equals(" ")? null : TalendDate.parseDate("yyyy-MM-dd",TalendDate.formatDate("yyyy-MM-dd",TalendDate.parseDate("yyyy-MM-dd HH:mm:ss",(row5.seniority_date))))

Please find attached screenshot for the same. Please help me to resolve this.

Re: Inconsistent Date field while fetching from csv to postgresSQL !!!

Anonymous — Thu, 11 Jul 2019 12:42:31 GMT

In case you are storing row5.seniority_date as varchar, I suggest you try :

TalendDate.parseDate("yyyy-MM-dd HH:mm:ss",row2.seniority_date)

I should normaly convert the varchar to date.
If you want to remove time, I suggest you first use StringHandling.LEFT(row2.seniority_date,10) to extract only date without time before convert to date

Re: Inconsistent Date field while fetching from csv to postgresSQL !!!

gervit14 — Thu, 11 Jul 2019 14:15:08 GMT

Still facing the same issue.

Re: Inconsistent Date field while fetching from csv to postgresSQL !!!

Anonymous — Thu, 11 Jul 2019 14:58:32 GMT

Hi @gervit14 ,

In that case can you please try TalendDate.parseDate("yyyy-MM-dd",row5.seniority_date.substring(0,10))

Thanks and Regards,

Subhadip

Re: Inconsistent Date field while fetching from csv to postgresSQL !!!

gervit14 — Fri, 12 Jul 2019 10:53:08 GMT

Hi Subhadip,

The issue still persists. Still I am getting inconsistent data.

Re: Inconsistent Date field while fetching from csv to postgresSQL !!!

Anonymous — Thu, 18 Jul 2019 16:14:03 GMT

I'm not sure it's date conversion the issue

Re: Inconsistent Date field while fetching from csv to postgresSQL !!!

gervit14 — Fri, 19 Jul 2019 05:31:48 GMT

Same I was thinking, may be postgres internal time zone need to be checked or something...