timestamp without timezone format issue

[FrederikPM]

Querying a table with a column of the type timestamp without timezone returns the time in the given format: [date][“T”][time][“Z”].
However, the “Z” notation indicates that the time is UTC and as such I think the format should be changed to [date][“T”][time].

[Alkarex]

Hello,
Can you try your query directly on the PostgreSQL database?
I do not believe this Node-RED node does any transformation there

[FrederikPM]

Yes.
The following query: SELECT time FROM datatable LIMIT 1 gives:

[Alkarex]

And could you show some details of your flow / query in Node-RED as well as the result you get?

[FrederikPM]

Flow:

Query: SELECT time FROM datatable LIMIT 1;
Debug result: