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.
How do we solve this issue?
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?
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.
Could you please add a scenario we can use to reproduce the problem?
-Duser.timezone = 'Aisa/Shanghai' I use it and the seesion's timezone do work;