Skip site navigation (1) Skip section navigation (2)

Re: Timezone issues with Postrres

From: pratikchirania <pratik(dot)chirania(at)hp(dot)com>
To: pgsql-bugs(at)postgresql(dot)org
Subject: Re: Timezone issues with Postrres
Date: 2011-09-22 04:47:35
Message-ID: (view raw, whole thread or download thread mbox)
Lists: pgsql-bugs
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

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

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

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


View this message in context:
Sent from the PostgreSQL - bugs mailing list archive at

In response to


pgsql-bugs by date

Next:From: Tom LaneDate: 2011-09-22 05:42:54
Subject: Re: Timezone issues with Postrres
Previous:From: Tom LaneDate: 2011-09-22 04:24:04
Subject: Re: [v9.2] make_greater_string() does not return a string in some cases

Privacy Policy | About PostgreSQL
Copyright © 1996-2017 The PostgreSQL Global Development Group