Amazon RDS SQL Server set timezone at database level

4
votes

We recently moved the database to Amazon RDS SQL Server. We have some difficulties with the date times (timezone). By default RDS provides UTC date. Is there any way to overwrite / manipulate the local timezone at database level in SQL Server. Please help me on this.

Thanks in advance, SqlLover

1
amazon-rds
See my answer here: [stackoverflow.com/questions/21853530/… [1]: stackoverflow.com/questions/21853530/… - Neo

1 Answers

4
votes

https://forums.aws.amazon.com/thread.jspa?messageID=161339

The time zone is currently not modifiable. There is indeed a Parameter value in rds-describe-db-parameters called "default_time_zone" but it's marked as not modifiable.