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?