DataGrip TimeZone Oracle Result

The query in the database returns the date in the timezone UTC+0000 in the results.

Application and database settings:

  • "select sessiontimezone from dual;" - Result: "Europe / Moscow"
  • "select DBTIMEZONE from dual;" - Result "+03:00"
  • "select sessiontimezone from dual;" - Returns the correct current date

I tried to install the VM option "-Duser.timezone = +0300" This did not fix the problem.

How can I solve the problem so that the date in the results is in the time zone I need?

Please sign in to leave a comment.