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.