Postgres Pro
Downloads
Home   >   mailing lists

Timezone issues with Postrres - Mailing list pgsql-bugs

From pratikchirania
Subject Timezone issues with Postrres
Date
Msg-id 1316149023380-4809498.post@n5.nabble.com
Whole thread Raw
Responses Re: Timezone issues with Postrres  (Euler Taveira de Oliveira <euler@timbira.com>)
List pgsql-bugs
Tree view 
Hi,
I am experiencing the following anomaly while using postgres database:

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.

Regards,
Pratik Chirania
Hewlett Packard

--
View this message in context:
http://postgresql.1045698.n5.nabble.com/Timezone-issues-with-Postrres-tp4809498p4809498.html
Sent from the PostgreSQL - bugs mailing list archive at Nabble.com.

pgsql-bugs by date:

Previous
From: Heikki Linnakangas
Date:
Subject: Re: BUG #6209: Invalid subquery is accepted within a IN() clause
Next
From: "Richard G. Bayer"
Date:
Subject: BUG #6208: crash when c: occupied by removable drive