I kind of stumbled partly on the solution, in case anybody’s interested, I decided to set “Input Field Type” to “SetAstring”, which went well.
But Still the timezone bit is not inserted into the column but I guess I would have to add a parameter to the Extended Settings such as watt.adapter.JDBC.DateWithTimestampAndMillisecondsAndTimeZone or something.
Could you tell me where I can find a link to the 9.9 JDBC Adapter guide please ?
I first tried adding the two parameters to extended Settings but still got the same error.
Then on a hunch I tried SetAstring instead of String for “Input Field Type” which made it possible to insert the date but still without the timestamp, and then I switched timestamp to timestamp with timezone.