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. [grafik] In the next step, I removed [Europe/Berlin]. [grafik] That’s how it’s displayed in the Table Manipulator. [grafik] When writing to the PostgresSQL DB, I receive the following error message. [grafik] DB Row Inserter Execute failed: Error while adding rows #-1000 - #0, reason: Batch entry 0 INSERT INTO “digiklimap”.“rain_data” (“timeStamp”, “sensor_ID”, “device_ID”, “rain_fall”, “temperature”, “relative_humidity”, “wet_temperature”, “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 [grafik] Where is the error? What needs to be changed? I would appreciate your prompt advice. Best regards, Patrik

DB Row Inserter with PostgresSQL Error by DateTime Field

mlauber71 February 24, 2026, 10:44am 4

@PatrikS maybe you can take a look at this. Not sure if there have been updates to the drivers since then. I would have to investigate.

1 Like