Good day,
I have a list of warnings that I want to write to a database. I am using MSSQQL_JDBC_NONSPATIAL writer to write to our SQL Server database. One of the table attribute is the WarningTimestamp. (I set the type to datetime in the writer.) It is in ISO datetime format. When I want to write the records to the db, I always get an error telling me "MS SQL Server (JDBC) Writer: Error writing feature. Error: Attribute 'WarningTimestamp' does not contain a valid timestamp" even thought the WarningTimestamp is '2018-10-08T00:00:00'.
If I use the DateTimeConverter to convert the ISO datetime to FME datetime, the import is working. Why?
Please help.