[google-cloud-sql-discuss] Re: default_time_zone

did you get a solution for your issue ? 

On Thursday, March 15, 2018 at 7:11:37 AM UTC-4, Silambarasan Sekar wrote:

I have raised the issue in public issue tracker #74600960. Thank you!

Thanks & Regards

Venu
On Tuesday, March 13, 2018 at 9:58:36 PM UTC+5:30, nau...@google.com wrote:

Hello 

As you are already aware that you can set the offsets using the 'default_time_zone' flag [1], but this does not support daylight savings.

Currently, named time zones (for example, "Europe/Helsinki") are not supported. The documentation: MySQL Server Time Zone Support documentation[2] seems to work for first generation Cloud SQL instance. If you want this feature to support Named Time zone supporting daylight savings, I would suggest you to open a feature request using the public issue tracker[3].

[1] https://cloud.google.com/sql/docs/mysql-flags

[2] https://dev.mysql.com/doc/refman/5.5/en/time-zone-support.html
[3] https://cloud.google.com/support/docs/issue-trackers

On Monday, March 12, 2018 at 6:45:39 AM UTC-4, Silambarasan Sekar wrote:

Hi Team,

We are using Cloud SQL (mysql) second generation. We want our Cloud SQL instances to have Central Timezone.
The instances were have a database flag as "default_time_zone" as '-06:00' till now, since the day light started yesterday, we have to manually change the database flag of 'default_time_zone' to -05:00. The same happened on Nov 4th of 2017. 

The question I wanted to ask is, "Do we have to manually change the default_time_zone twice a year because of the day light savings or is there a mechanism in place that I am not aware of which will take care of this automatically." Thank you!

Thanks & Regards
Venu

--
You received this message because you are subscribed to the Google Groups "Google Cloud SQL discuss" group.
To unsubscribe from this group and stop receiving emails from it, send an email to google-cloud-sql-discuss+unsubscribe@googlegroups.com.
To view this discussion on the web visit https://groups.google.com/d/msgid/google-cloud-sql-discuss/ec9ca797-1688-4a08-af31-424ebbb041f9%40googlegroups.com.
For more options, visit https://groups.google.com/d/optout.