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: