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: 1316666855451-4828973.post@n5.nabble.com (view raw or flat)
Thread:
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
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.

In response to

Responses

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-2014 The PostgreSQL Global Development Group