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

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

Europe/Oslo
Europe/Paris
Europe/Podgorica
Europe/Prague
Europe/Riga
Europe/Rome
Europe/Samara

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