On Wed, Oct 28, 2015 at 6:43 AM, Edson Richter <edsonrichter@xxxxxxxxxxx> wrote: > Configured since first setup. Brazil went DST few days ago. > Today, executing > Select now() > Resulted in > > 2015-10-28 02:45:37-03:00 > > I do expect > > 2015-10-28 03:45:37-02:00 > > I suspect that Postgres is ignoring the DST change. Have you checked the timezone definitions are correct in the server machine? I.e., doing something like this on it: $ TZ="America/Sao_Paulo" date -R Wed, 28 Oct 2015 10:09:19 -0200 $ TZ="America/Sao_Paulo" date -R -d '1 month ago' Mon, 28 Sep 2015 09:09:55 -0300 ( I'm not familiar with your distro, but I got bitten by one of those soem years ago, incorrect timezone definitions ) Francisco Olarte. -- Sent via pgsql-general mailing list (pgsql-general@xxxxxxxxxxxxxx) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general
