DB Row Inserter with PostgresSQL Error by DateTime Field

Hello

For a project, I need to read sensor data via a REST API. The data is returned in JSON format. The timestamp is returned as a number. See column KEY. It should be in UNIX format. I converted this using the Node UNIX Timestamp to Date&Time. Column key TimeStamp.

In the next step, I removed [Europe/Berlin].

That’s how it’s displayed in the Table Manipulator.

When writing to the PostgresSQL DB, I receive the following error message.

DB Row Inserter

Execute failed: Error while adding rows #-1000 - #0, reason: Batch entry 0 INSERT INTO “digiklimap”.“raindata” (“timeStamp”, “sensorID”, “deviceID”, “rainfall”, “temperature”, “relativehumidity”, “wettemperature”, “docCount”) VALUES ((‘2025-12-20T00:00+01:00’),(‘RC0040176’),(‘118295’),(‘1.016’::double precision),(‘5.717’::double precision),(‘99.989’::double precision),(‘5.716’::double precision),(‘96’::int4)) was aborted: FEHLER: Spalte »timeStamp« hat Typ timestamp with time zone, aber der Ausdruck hat Typ character varying Hinweis: Sie müssen den Ausdruck umschreiben oder eine Typumwandlung vornehmen. Position: 166 Call getNextException to see other errors in the batch.

Table in Postgres

Where is the error? What needs to be changed?

I would appreciate your prompt advice.

Best regards,

Patrik