CODEWITHSUNDEEP
mysqlgoogle-cloud-storagegoogle-cloud-sqlgoogle-cloud-platform
Dor Shay
Dor Shay

Reputation: 53

Google Cloud SQL and time zones

I'm developing an app that meant to run only in Israel. All of our tables contains times at Israeli time (Tel Aviv time).

because the SQL in GCP doesn't support default timezone and time zone convert I got stuck.

how can I convert times between time zones?

let me remind you that Israel has a light saving time change.

Upvotes: 4

Views: 7900

Answers (3)

Ecuador
Ecuador

Reputation: 1177

Cloud SQL now supports named time zones. See a list here: https://cloud.google.com/sql/docs/mysql/flags#timezone-names

When using timezone names, automatic adjustment to daylight saving time is supported.

What is weird is that even though when explaining named time zones it gives the example Europe/London, in the actual list that's missing. The closest equivalent is Europe/Dublin, which is functionally the same although their summer time is considered "standard" so they switch to winter time.

Upvotes: 0

David
David

Reputation: 9731

THIS ANSWER IS OBSOLETE

On Google Cloud SQL you cannot currently set your own time zone. If you need to change the time zone on your instance, please get in touch with [email protected].

Upvotes: -1

Tony Tseng
Tony Tseng

Reputation: 479

Now you have the ability to set the time zone in Cloud SQL. See https://cloud.google.com/sql/docs/mysql-flags. The limitation is that the time zone needs to be specified as offsets to UTC, such as '+10:00'. It does not support named time zones like 'Europe/Helsinki'.

Upvotes: 8

Related Questions