topic Problem with Date import into MySQL (date imported with wrong year) in Data Quality

Problem with Date import into MySQL (date imported with wrong year)

Anonymous — Sat, 16 Nov 2024 09:38:23 GMT

Hi all,

I am trying to import .txt file into MySQL database, and all columns are being imported but I am having an issue with the date where the year is showing 0015 or 0016 instead of 2015 or 2016.

The date column in the .txt file

27-Jul-15

20-Oct-15

25-May-15

What is being imported into the database:

0015-07-27

0015-10-20

0015-05-25

I tried ParseDate, FormatDate and even without expression but doesn't seem to solve it.

What am I doing wrong ?

Re: Problem with Date import into MySQL (date imported with wrong year)

smallet — Tue, 13 Jun 2017 14:00:40 GMT

Hi,

Could you be a little more precise?

Like which product are you using? Which version?

If it's Studio, capture (at least) of your job?

Thx

Re: Problem with Date import into MySQL (date imported with wrong year)

Anonymous — Tue, 13 Jun 2017 14:15:46 GMT

Hi smallet,
Thanks for quick reply!

I am using Talend Open Studio for Data Integration Version: 6.4

And this is the job i am doing:

Re: Problem with Date import into MySQL (date imported with wrong year)

smallet — Tue, 13 Jun 2017 14:23:39 GMT

So, you're using the Studio, that's good to know.

Could add more information, like the original file, the job?

Re: Problem with Date import into MySQL (date imported with wrong year)

Anonymous — Tue, 13 Jun 2017 14:32:45 GMT

the original file is a .txt and Date column as "dd-MMM-yyyy" as I added also as Metadata delimited file.

And Tmap as follows without any expression:

It is importing month and day correctly but the year is starting with 00 instead of 20 (0016 instead of 2016)

Re: Problem with Date import into MySQL (date imported with wrong year)

Anonymous — Tue, 13 Jun 2017 15:23:15 GMT

Found the issue... so simple !

the txt had the date as dd-MMM-yy while i was using dd-MMM-yyyy

cheers