CODEWITHSUNDEEP
google-cloud-sql
Nir Zohar
Nir Zohar

Reputation: 51

How to set a timezone for MySql Google Cloud SQL

Tried to create new costume flag from the developer console - doesn't work. Tied from the command line: gcloud sql instances patch --database-flags time_zone Doesn't work, get error: "invalidFlagName"

Upvotes: 5

Views: 4057

Answers (2)

Jay Zhu
Jay Zhu

Reputation: 49

There is a database flag "default_time_zone" in developer console that you can use to specify timezone offset when you create a new instance or edit an existing instance.

See https://cloud.google.com/sql/docs/mysql-flags for detailed info.

Upvotes: 4

Razvan Musaloiu-E.
Razvan Musaloiu-E.

Reputation: 1320

The MySQL timezone tables are not populated so that flag is not supported via the --database-flags or web UI. If you are happy maintaining the tables yourself then ping us at [email protected] with the setting you want and we'll manually set it.

Upvotes: -1

Related Questions