Time zone problem with google cloud

nmoda · 12-09-2021 03:13 AM

Hello,

I have installed a website on google cloud vm and i am new to this. I have a plugin which i have migrate with my own financial program. But the time zones differents makes it so hard for me to print out billings and so on. The problem started out last week and now with my real time and sql or vm instance time has 1 hour difference. I have checked the time zone on my instance and is says central europe (warsaw) which i am in currently. But still time is wrong. Could you please tell me what to do?

As you can see here it says server time 08:35 but my real time was 09:36

And as you can see my time zone seems correct. So what should i do?

tauqeerahmad

You can set the time zone in Cloud SQL [1]. 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.

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