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