please help us set timezone of our all db into Asia/Singapore (urgent)

We check all documents we can but are still unable to set the timezone from UTC to Singapore on our database,please help us set it asap

Submit an answer
Answer a question...

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!

Sign In or Sign Up to Answer

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.

Site Moderator
Site Moderator badge
April 14, 2022

Hi @BubblyGreenBlueShark,

Depending on the product you are using the way to set this is different.

Let’s assume you are using Managed Database, in such a case, you’ll need to contact DigitalOcean’s support to change it for you as currently you can’t do it from your end.

If you have a separate Droplet that you’ve installed an SQL instance on it, you’ll need to change the timezone of the Droplet.

ssh root@YourDropletIp

As soon as you are in, you can check your timezone using the timedatectl command. The system timezone is configured by symlinking /etc/localtime to a binary timezone identifier in the /usr/share/zoneinfo directory. Alternatively, you can also check the current system’s timezone by displaying the contents of the /etc/timezone file.

cat /etc/timezone

There are a few possibilities to change the timezone. The first one is using timedatectl

timedatectl list-timezones

You’ll something like


Once you identify which time zone is accurate to your location, run the following command:

sudo timedatectl set-timezone your_time_zone

For example, to change the system’s timezone to Europe/Rome:

sudo timedatectl set-timezone Europe/Rome ```

Run the timedatectl command to verify the changes

Hi @BubblyGreenBlueShark,

What database are you using? It’s a managed database by Digitalocean or standalone installation?

Regards - Sergio Turpín