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?
Hi
What's the expected result if the datetime is "0000-00-00 00:00:00" in Mysql table? Below is an expression used to set the column as null if the datetime is "0000-00-00 00:00:00" , on tMap:
row1.columnName.getTime()<=0?null:row1.columnName
Has this issue been resolved? I added the parameter "noDatetimeStringSync=true&zeroDateTimeBehavior=convertToNull" to my MySQL connection as I saw in a few posts. When I use the querybuilder to query the data, it shows null. However, when I look at my data in a tLogRow, I'm seeing 31-12-0002. When I try to put this value into another database, it gives a error that says "Only dates in the AD era are accepted."
