DateTime issue

[Anonymous]

Hi,
I'm reading data through tMysqlInput and storing it as it is in a csv file. The table has a DateTime column and it sometimes has a value of '0000-00-00 00:00:00' but this value is stored in csv as '0002-12-31 00:00:00'. I'm also attaching tMysqlInput table schema. any idea?

[Anonymous]

also attaching the schema of tFileOutputDelimited.
regards,

[Anonymous]

Hi abdul_rehman,
Do you have null values in the data that you're reading? Maybe it is just giving the default value to the nulls.

[Anonymous]

Hi Khor,
the source table has '0000-00-00 00:00:00' which are stored as '0002-12-31 00:00:00', and you can also see that the default value of the column is set to '0000-00-00 00:00:00'.

[Anonymous]

Hi,
Maybe you should test the date in a tmap. Which version of Talend do you use?

[Anonymous]

Hi Or3l,
There is a tMap but i'm not doing any transformation there. And i'm using 4.2.2.
regards,

[Anonymous]

Hi,
also tested the date column in tMap and entered '0000-00-00 00:00:00' in date column value and tested it. The output was '0000-00-00 00:00:00'.

[Anonymous]

Hi,
any idea guys? or i have to deal with this with a case statement in LDR script?
regards,

[Anonymous]

Hi,
I've gotten the exact same thing.
Instead of 0000-00-00 00:00:00
I get '0002-12-31 00:00:00' when data is pulled into Talend.
My job pulls the data from a MySQL table.
When look at the table from MySQL Workbench it says correctly 0000-00-00 00:00:00
Any ideas?

[Anonymous]

It is caused because 0000-00-00 00:00:00 is not a valid date. It's a "bug" in MySQL. The first valid date should be 0001-01-01 00:00:00
there is never a day between the 31-12 and 1-1 by the way.