2
I’m starting to use AWS services and came across a "problem" on Amazon RDS. I use Sql Server and it updates your time according to the server time, but when I select the time related to mine time zone UTC-03:00 (Greenland on RDS server) it does not recognize daylight saving time.
In the AWS documentation he says that time zone recognizes summer times. If I use the Brazilian Standard time, He even recognizes daylight savings. but they use Manaus as a base which leaves my time wrong, because I’m in Rio de Janeiro and here we based by Brasilia UTC-03:00.
Has anyone ever had this problem? How did it solve?
Hi, see if that documentation help you.
– Danilo Silva
Danilo, thanks for the answer, but I’ve seen this documentation too. The problem that the area that should understand Brazil ( central Brazilian Time) It is as Amazon what does not serve for those who live in most of Brazil that uses Brasilia as standard. The standard of Amazon of UTC -03:00 that comprises the schedule used in Rio and in more than half of the Brazilian states this as Greenland and and does not apply the change of schedule which leaves my bank always an hour ago.
– Damião Tenorio
I got it. I have a mysql instance in the São Paulo region that came by default as UTC and is right with daylight saving time.
– Danilo Silva
Change your Timezone to GMT+2 in your RDS Option groups if it is postgresql, if it is Mysql you will have to put Brazil/East
– Jefferson Otoni Lima
-1 How to do this? How to get to this option? Many details are missing in your answer.
– Wallace Maxters
This is a matter of support (server configuration) that depends on the peculiarity of the contracted service, not programming. Can be done in English at http://superuser.com or http://serverfault.com Anyway, comments are still open for anyone who can help. If within this problem you have any questions about a specific configuration of a common tool within the scope can [Edit] the issue focusing only on that (and posting all relevant data as current configuration) for the community to reevaluate.
– Bacco