DST question

From: "Wright, George" <George(dot)Wright(at)infimatic(dot)com>
To: <pgsql-novice(at)postgresql(dot)org>
Subject: DST question
Date: 2007-10-01 17:19:47
Message-ID: 51548D6D5BEB57468163194A8C1A0E983193D7@MAGPTCPEXC02.na.mag-ias.net
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-novice

I am trying to get Daylight Savings Time working for the EAST Brazilian
time zone. In Brazil for 2007, the DST change occurs on Oct. 13-14.

I tried setting the DB to each of the following time zones with the
statement: SET SESSION TIME ZONE <TZ>;

Where <TZ> was one of the following:

'America/Sao_Paulo Brazil/East';

'EBST3EBDT';

'BRT'

The DST switch appears to happen on 10/28/2007 between the hours of 1am
and 2am with all 3 of those strings.

The output of select version(); is:

PostgreSQL 8.1.5 on x86_64-unknown-linux-gnu, compiled by GCC gcc (GCC)
4.1.2 20061115 (prerelease) (SUSE Linux)

O/S is Suse 10.2

How do I get the proper DST for East Brazil to work?

Thanks.

Responses

Browse pgsql-novice by date

  From Date Subject
Next Message Tom Lane 2007-10-01 17:24:41 Re: [HACKERS] PG on NFS may be just a bad idea
Previous Message Josh Berkus 2007-10-01 17:13:41 Re: [HACKERS] PG on NFS may be just a bad idea