You signed in with another tab or window. Reload to refresh your session.You signed out in another tab or window. Reload to refresh your session.You switched accounts on another tab or window. Reload to refresh your session.Dismiss alert
When inspecting the value of a record copied using the option "Advanced Copy" > "Copy as JSON" certain date types (Oracle) and timestamp (Postgres) do not represent the information stored in the database
The table is mirrored in Postgres and Oracle
DBeaver Version
Community Edition Version 24.0.4.202405051837
Operating System
Windows 10 x64
Database and driver
Database: Postgres 14.11
Driver Name and version: PostgreSQL JDBC Driver
Hello, I tried checking the option, then exporting the data to a .json and the clipboard and both options kept the wrong date times.
Note: The copied time does not correspond to the local machine time
Description
When inspecting the value of a record copied using the option "Advanced Copy" > "Copy as JSON" certain date types (Oracle) and timestamp (Postgres) do not represent the information stored in the database
The table is mirrored in Postgres and Oracle
DBeaver Version
Community Edition Version 24.0.4.202405051837
Operating System
Windows 10 x64
Database and driver
Database: Postgres 14.11
Driver Name and version: PostgreSQL JDBC Driver
Steps to reproduce
As an example in Postgres:
We have certain table with this row
The value of the cell is
2024-05-13 19:35:46.807
I query the table using the Dbeaver view, then I select the whole row, next I use the option "copy as JSON"
Then I paste the json in any editor and I get the wrong time
Additional context
SSL: Use SSL ON, SSL mode: allow
The text was updated successfully, but these errors were encountered: