Re: Timezone issues with Postrres

Hi, thanks for the responses. Here are updates from my end:

1. I am in Costa Rica, using Windows Server 2008 R2/Windows 2003 with
PostgreSQL 8.3/9.0

2. System Date/Time Settings shows "CST/Central America" with UTC-6 as extra
display

system timezone: (using command: systeminfo)
Time Zone:                 (UTC-06:00) Central America

3. other applications are showing the correct time (i.e., the System Time
setting IS correct as can be confirmed by a time checker such as
http://www.timeanddate.com/worldclock/)

4. There is NO DST for CST (Central America) a.k.a America/Costa_Rica to the
PostgreSQL database through the pg_timezone_names view

5. If the America/Costa_Rica entry is made in the posgresql.conf file
(timezone field), it works as expected and matches the System TimeZone/Date
and Time

Here are the results you had requested for:

show timezone
"CST6CDT"


select now() at time zone 'utc', now() at time zone 'utc -6', NOW();

"2011-09-22 02:50:49.746"; "2011-09-22 08:50:49.746"; "2011-09-21
21:50:49.746-05"

regards,
Pratik

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