Amazon RDS Custom for SQL Server now supports Local Time Zones. You can now set the time zone for your Amazon RDS Custom for SQL Server instances to the local time zone of your choice. Amazon RDS Custom for SQL Server is a managed database service that allows customization of the underlying operating system and database environment.
Source:: Amazon AWS