timestamp without timezone format issue

alexandrainst / node-red-contrib-postgresql

Node-RED node for PostgreSQL, supporting parameters, split, back-pressure

https://flows.nodered.org/node/node-red-contrib-postgresql

Apache License 2.0

31 stars 13 forks source link

timestamp without timezone format issue #71

Open FrederikPM opened 3 months ago

FrederikPM commented 3 months ago

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 commented 3 months ago

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

FrederikPM commented 3 months ago

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

Alkarex commented 3 months ago

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

FrederikPM commented 3 months ago

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