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
--
Sent via pgsql-bugs mailing list (pgsql-bugs@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-bugs
