Change Default Timezone on cloud Sql instance

[Mua Rachmann]

Hi,

I have been trying to change the default timezone in the cloud sql instance to no avail. i keep getting the default timezone of  date: 2019-10-01 08:39:19.785535 America/New_York (-04:00) for example when when i echo the date time. I have followed the instructions on changing the flags here https://cloud.google.com/sql/docs/mysql/flags#mysql-d and changed several times and it prompts me to restart, yet it keeps giving me the same time offset of new york. 

How can this be fixed? please. Currently my app needs to be accessed by various countries but  this limits it.

Regards,

Mua

[George (Cloud Platform Support)]

Hello Mua, 

How did you change the default_time_zone flag, exactly. Did you use the command line with gcloud sql instances patch [INSTANCE_NAME] --database-flags [FLAG1=VALUE1,FLAG2=VALUE2]? Did you use Cloud Console? Worth noting: leading zeros required. 

You mention echoing the date time. What is the output of SHOW VARIABLES; ? What is the value of system_time_zone? Are values of the two flags identical? 

This discussion group is oriented more towards general opinions, trends, and issues of general nature touching the app engine. For Cloud SQL setup, you may be better served in dedicated forums such as stackoverflow, where experienced programmers are within reach and ready to help.