topic date format resulting date -1 in the result in Talend Studio

date format resulting date -1 in the result

Anonymous — Sat, 16 Nov 2024 03:25:44 GMT

I am trying to fetch the date from date-time column, but I see some of the records are getting date-1 in the result. please help

my source date column data looks like this .

column user_created_on is the source and calendar date is the result which I am getting.

I have used 'TalendDate.parseDate("yyyy-MM-dd",TalendDate.formatDate("yyyy-MM-dd",ST_User_Repo.relationship_created_on )) ' This fumction to get the result

Re: date format resulting date -1 in the result

PhilHibbs — Wed, 29 Jan 2020 10:08:40 GMT

That's very odd, I can't replicate that behaviour. Are you sure that the relationship_created_on column is the same as the user_created_on in the data that you are showing?

Can you try feeding a date that is the 1st of the month, to see if it shows 00 or the last day of the previous month? That will tell you if it is really subtracting one from the date, or whether it is rendering the day of the month with a zero base instead of a 1 base.