Skip site navigation (1) Skip section navigation (2)

Re: Timezone issues with Postrres

From: Euler Taveira de Oliveira <euler(at)timbira(dot)com>
To: pratikchirania <pratik(dot)chirania(at)hp(dot)com>
Cc: pgsql-bugs(at)postgresql(dot)org
Subject: Re: Timezone issues with Postrres
Date: 2011-09-16 15:01:12
Message-ID: 4E7364B8.5070608@timbira.com (view raw or flat)
Thread:
Lists: pgsql-bugs
On 16-09-2011 01:57, pratikchirania wrote:
> Time is being interpreted incorrectly when I set time zone to UTC -6
> (Central America).
> Time shown when I query "SELECT NOW()" is 1 hour ahead of system time.
> PS: Central america does not have daylight saving. That might not be the
> issue.
>
It is not a bug. Was is the exact postgresql version? How old is your 
installation? It seems your PostgreSQL or OS tzdata is not up to date. If 
'pg_config --prefix' command has '--with-system-tzdata' update your 
installation to the latest minor version (for example, 8.4 -> 8.4.8) else 
update your OS tzdata and restart the PostgreSQL.


-- 
    Euler Taveira de Oliveira - Timbira       http://www.timbira.com.br/
    PostgreSQL: Consultoria, Desenvolvimento, Suporte 24x7 e Treinamento

In response to

Responses

pgsql-bugs by date

Next:From: Caleb WeltonDate: 2011-09-16 17:10:56
Subject: BUG #6212: PREPARE(pseudotype) should be blocked off
Previous:From: Norman PalardyDate: 2011-09-16 14:41:34
Subject: BUG #6210: Description of PQconnectdbParams in documentation

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group