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

[gervit14]

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.

[Anonymous]

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

[gervit14]

Still facing the same issue.

[Anonymous]

Hi @gervit14 ,

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

Thanks and Regards,

Subhadip

[gervit14]

Hi Subhadip,

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

[Anonymous]

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

[gervit14]

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