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
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
pgsql-bugs by date
|Next:||From: Caleb Welton||Date: 2011-09-16 17:10:56|
|Subject: BUG #6212: PREPARE(pseudotype) should be blocked off|
|Previous:||From: Norman Palardy||Date: 2011-09-16 14:41:34|
|Subject: BUG #6210: Description of PQconnectdbParams in documentation|