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

You can use something like:

SET GLOBAL time_zone = 'Europe/Paris';

In a cron task to be sure you are in the right timezone (summer and winter time).

On Monday, March 12, 2018 at 11:45:39 AM UTC+1, 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/8df19297-2575-4ee9-ba80-530a8f99a112%40googlegroups.com.