Discussions
Categories
- 384.5K All Categories
- 2.5K Data
- 551 Big Data Appliance
- 1.9K Data Science
- 451.3K Databases
- 222.1K General Database Discussions
- 3.8K Java and JavaScript in the Database
- 32 Multilingual Engine
- 560 MySQL Community Space
- 479 NoSQL Database
- 7.9K Oracle Database Express Edition (XE)
- 3.1K ORDS, SODA & JSON in the Database
- 561 SQLcl
- 4K SQL Developer Data Modeler
- 187.4K SQL & PL/SQL
- 21.4K SQL Developer
- 296.8K Development
- Application Development
- 18 Developer Projects
- 140 Programming Languages
- 293.5K Development Tools
- 112 DevOps
- 3.1K QA/Testing
- 646.2K Java
- 28 Java Learning Subscription
- 37K Database Connectivity
- 193 Java Community Process
- 106 Java 25
- 22.1K Java APIs
- 138.2K Java Development Tools
- 165.3K Java EE (Java Enterprise Edition)
- 21 Java Essentials
- 165 Java 8 Questions
- 86K Java Programming
- 81 Java Puzzle Ball
- 65.1K New To Java
- 1.7K Training / Learning / Certification
- 13.8K Java HotSpot Virtual Machine
- 94.3K Java SE
- 13.8K Java Security
- 206 Java User Groups
- 24 JavaScript - Nashorn
- Programs
- 525 LiveLabs
- 39 Workshops
- 10.2K Software
- 6.7K Berkeley DB Family
- 3.5K JHeadstart
- 5.7K Other Languages
- 2.3K Chinese
- 178 Deutsche Oracle Community
- 1.1K Español
- 1.9K Japanese
- 236 Portuguese
MySQL v5.7.18 time stamp and time zone problem
Hello! It is me again!
I have 2 installations of MySQL v5.7.18. One is on Oracle Linux 7.3 and the other is on Ubuntu 16.04.
Both of their mysql log records show time stamp in GMT (UTC). I have checked my system OS's time zone setting and they are set correctly to my local time zone GMT+8.
So how do I make the mysql log records being shown in my local time zone? In the older version of mysql, their log records were shown in my local time zone.
Hope to hear your helpful opinion.
Best Answer
-
Hello Friends,
I find a variable log_timestamps which is set to UTC by default.
I think it can be set to my local time zone.
Answers
-
What is your time_zone and system_time_zone set to?
For example:
[[email protected] ~]# dateSat May 6 18:49:51 AEST 2017[[email protected] ~]# date -uSat May 6 08:49:56 UTC 2017 [[email protected] ~]# mysql -p -se "SHOW VARIABLES" | grep time_zone
Enter password:system_time_zone AESTtime_zone SYSTEM[[email protected] ~]#Check your settings.
...and read this.
https://dev.mysql.com/doc/refman/5.7/en/time-zone-support.html
Cheers,
Gaz.
-
what does your 'SHOW VARIABLES LIKE 'SYSTEM_TIME_ZONE''; show?
The relevant man page https://dev.mysql.com/doc/refman/5.7/en/time-zone-support.html
Dave Stokes
MySQL Community Manager
-
Dave Stokes
MySQL Community Manager
-
Hello Friends,
I find a variable log_timestamps which is set to UTC by default.
I think it can be set to my local time zone.
-
Dave Stokes
MySQL Community Manager
