As mentioned in my other post, I ran this test on the other test wordpress installation and had the same issue with decimals in the wrong place.
However the created_time data is now being inserted into the database on the test installation, the difference between the two is the production server is using a digital ocean managed MYSQL server.
Going to test the same thing on a DO database. to see if that is an issue.