dbforge ignores server defaul timezone

Discussion of open issues, suggestions and bugs regarding database management and administration tools for MySQL
Post Reply
usr
Posts: 1
Joined: Mon 14 Jan 2019 10:37

dbforge ignores server defaul timezone

Post by usr » Mon 14 Jan 2019 11:28

When I query some request to mysql server, latest dbforge studio always show time stapms in strange format. Mysql default time is moscow:
$ time
Mon Jan 14 14:16:50 MSK 2019
mysql
$ mysql
> SELECT @@global.time_zone, @@session.time_zone;
@@global.time_zone | @@session.time_zone |
+--------------------+---------------------+
| SYSTEM | SYSTEM
but when I add data row at 14:08 (MSK) to mysql DB, dbrorge get some time zone, other then default system:

14.01.2019 6:08:56

alexa
Devart Team
Posts: 2719
Joined: Fri 24 Jun 2011 14:17

Re: dbforge ignores server defaul timezone

Post by alexa » Tue 15 Jan 2019 12:12

This can be setup in the 'Data Editor -> Formatting' section of the 'Options' window that can be invoked by selecting 'Tools -> Options...' from the main menu.

Post Reply