@denis
The system_time_zone in MySQL represents the time zone setting of the operating system where MySQL is running. To change the system_time_zone in MySQL, you will need to perform the following steps:
1
|
SELECT @@system_time_zone; |
1
|
SET GLOBAL time_zone = 'UTC'; |
Note: You can replace 'UTC' with your desired time zone, such as 'America/New_York' or 'Asia/Kolkata'. Make sure to use the correct time zone identifier, as defined in the MySQL time zone tables.
1
|
SELECT @@system_time_zone; |
The output should display the new system_time_zone value that you set.
By following these steps, you can successfully change the system_time_zone in MySQL.