dbforge ignores server defaul timezone
Posted: 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
$ 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