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?

4 comments
Comment actions Permalink

How do we solve this issue?

0
Comment actions Permalink

Hello guys, could you please clarify the problem. Where the query is correct and where is not?

What version of Oracle Server and JDBC driver do you use?

How did you set the JVM option?

0
Comment actions Permalink
  • Oracle 12.2
  • JDBC Driver - whichever one comes with 2020.1.2

I don't remember now but I tried options from here https://intellij-support.jetbrains.com/hc/en-us/articles/115000877044-DataGrip-FAQ and none helped.

0
Comment actions Permalink

Could you please add a scenario we can use to reproduce the problem?

0

Please sign in to leave a comment.