Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hello,
I have a problem with my Talend 6.2.1 when I try to save a DATETIME data containing milliseconds.
The problem is that these milliseconds are truncated and replaced by . 000 in the database.
Here is a list of everything I have:
- Talend TOS V6.2.1
- Mariadb 10.2.10
- MSSQL server 2008
My processing is quite simple, I recover data from the MSSQL Server, let us take as an example "2016-01-01 12:52:23.155".
I then run it through a Tlogrow to make sure it’s still full, and it is.
To finish I import it directly into a database Mariadb 10.2.10.
When I check my data in the database, it was changed in "2016-01-01 12:52:23.000".
In Database, the column is DATETIME(3) and on Talend I use the date format "yyyy-MM-dd HH:mm:ss.SSS"
I have already tested several patches like adding "useFractionalSeconds=true" in the additional settings of my connection.
I tried to save the data in a csv file, and the milliseconds were there.
I am attaching some screenshots to help you understand my current state.
Best regards,
Arnaud Delaunay, French guy.