Azure PostgreSQL Flexible server Time Zone need to change

Question

Azure PostgreSQL Flexible server Time Zone need to change from default UTC to IST, hence need assistance to change the same.

Answer 1

@Navnath Manere
Thank you for the question and for using Microsoft Q&A platform.
As per my understanding, you want to change the timezone in Azure PostgreSQL Flexible server from UTC to IST(Asia/Kolkata).

You can change the time zone for your Azure PostgreSQL Flexible Server from UTC to IST by following these steps:

1. Open the Azure Portal and navigate to your Azure Database for PostgreSQL Flexible Server instance.
2. Go to the “Server Parameters” section under the SETTINGS menu.
3. Search for the TimeZone parameter. You can use the search box to quickly find it.
4. Change the TimeZone parameter to Asia/Kolkata (which represents IST).
5. Save the changes.

Verification:

To confirm the time zone change:

1. Connect to the PostgreSQL database using a tool like psql, Azure Data Studio, or any PostgreSQL client. I have used Azure Data Studio.
2. Run the following SQL query:

      SHOW timezone;
      
      
   

Hope this helps. Do let us know if you have any further queries.

---

If this answers your query, do click Accept Answer and Yes for was this answer helpful. And, if you have any further query do let us know.