| 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 |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| 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
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Caleb Welton | 2011-09-16 17:10:56 | BUG #6212: PREPARE(pseudotype) should be blocked off |
| Previous Message | Norman Palardy | 2011-09-16 14:41:34 | BUG #6210: Description of PQconnectdbParams in documentation |