Skip to content
By using AWS re:Post, you agree to the AWS re:Post Terms of Use
AWS re:Postre:Post
About re:Post

Help me change the Time zone of RDS-DB SQL Server

0

I have a current db running with time zone UTC and I want to change the time zone GMT+7 for the same time in my country. I have researched and understand we can't do this with db running. We just change the time zone when create a new DB. Anything else advice for my case?

Topics
Database
Tags
Database
Language
English
asked a year ago610 views
2 Answers
1

Hi,

Follow the guidance of this KC article: https://repost.aws/knowledge-center/rds-change-time-zone

It just describes exactly what you want to achieve.

Best,

Didier

EXPERT
answered a year ago
EXPERT
reviewed a year ago
EXPERT
reviewed a year ago
0

Hey bro,

I think you can run a SQL Query to change time zone data.

Try this:

SELECT 
    YourUTCTimeColumn,
    YourUTCTimeColumn AT TIME ZONE 'UTC' AT TIME ZONE 'Eastern Standard Time' AS LocalTime
FROM 
    YourTable;
answered a year ago
  • ThanhND
    a year ago

    this just changed the column of the table, I want to change the time of the db name. I have many columns query time zone, it does not work in my case.

You are not logged in. Log in to post an answer.

A good answer clearly answers the question and provides constructive feedback and encourages professional growth in the question asker.

Relevant content