LAE

I am working on a process copy data from one table to another table in a new database.

I am extracting one of the datetime fields as a text and converting it back into a datetime field with milliseconds

When loading the datetime field that contains milliseconds into an oracle table using the oci driver. The insert process seems to drop the milliseconds from the load

Any help would be greatly appreciated.

Have you considered using the JDBC Execute node as an alternative?

What is the data type of the field within the database table? The field needs to be a TIMESTAMP rather than a DATE.

Note: This was originally posted by an inactive account. Content was preserved by moving under an admin account.

Just backing up what Adrian has said above with a link from stack overflow. Date stores to nearest second, Timestamp is for millisecond. It's discussed here.