Report this

What is the reason for this report?

Digital Ocean Managed Databases Set Timezone to UTC -05:00 Permanently

Posted on June 17, 2020

I’ve searched the docs and forums regarding the forementioned subject, but I can’t seem to find a way to set the global timezone for my managed database to UTC -05:00. Any help would be greatly appreciated.



This textbox defaults to using Markdown to format your answer.

You can type !ref in this text area to quickly search our full set of tutorials, documentation & marketplace offerings and insert the link!

These answers are provided by our Community. If you find them useful, show some love by clicking the heart. If you run into issues leave a comment, or add your own answer to help others.

Hey @GSDynamicsDO,

Unfortunately at this time, it seems that you can’t set this yourself rather annoyingly.

However, if you create a support ticket, our teams can manually set it for you :) Please note that changing the timezone will affect the whole cluster.

You can reach out to our support team via https://www.digitalocean.com/support/

Hope that helps! - Matt.

Hello @rajkishore

You can check this question that was previously asked in our community:

https://www.digitalocean.com/community/questions/can-i-change-timezone-in-the-do-managed-mysql-database

The easiest way to do this now is via the DigitalOcean API.

First, use a GET request to get a list of your databases, and take the ID of the database you’re looking to change the settings for.

Then, use this API call: https://docs.digitalocean.com/reference/api/api-reference/#operation/databases_patch_config

Using your auth token and the body:

  1. {"config": { "default_time_zone": "Europe/London" }} <-- Change the timezone as you wish.

This should set the timezone for your server 👍

Regards

The developer cloud

Scale up as you grow — whether you're running one virtual machine or ten thousand.

Get started for free

Sign up and get $200 in credit for your first 60 days with DigitalOcean.*

*This promotional offer applies to new accounts only.