dbeaver: Date field values do not match with the ones shown by both, my system and mysql console

System information:

  • OS: macOs High Sierra 10.13.6
  • DBeaver version: 6.1.10

Connection specification:

  • MySQL 8.0.16
  • JDBC
  • Not using tunnels or proxies

Describe the problem you’re observing:

The problem is kind of simple to describe. The past Monday I just downloaded the new release of your system, I installed it, and apparently, there wasn’t any problem. But right now I’m working with date fields, and I think that there could’ve been some trouble in your latest version. Basically, when try to store this information into the database:

Captura de pantalla 2019-06-12 a la(s) 12 06 53

Then, I dump this information in the browser to see what is being sent to the server:

Captura de pantalla 2019-06-12 a la(s) 12 09 45

And then, I store the record and the database shows incorrect values for the fields begining_date and expiration_date :

Captura de pantalla 2019-06-12 a la(s) 12 11 24

As you can see, the days in those fields seems to be decreasing by one, and a curious thing is that, today earlier, they were increasing.

But, the weirdest thing is that when I try to see the data in my system. It show this: Captura de pantalla 2019-06-12 a la(s) 12 13 09

And also when I do a query in Mysql CLI, it shows the same dates as the previous image.

Steps to reproduce, if exist:

Include any warning/errors/backtraces from the logs

About this issue

  • Original URL
  • State: closed
  • Created 5 years ago
  • Comments: 15 (5 by maintainers)

Commits related to this issue

Most upvoted comments

I just updated to the version 6.1.4 today (Aug 5th, 2019), but the error remains there for me too. What can we do? An error as basic like this and no one fixes it… I believe, no I’m sure, that many users are likely to be affected by this error and have not yet realized.