| From: | Michael Fuhr <mike(at)fuhr(dot)org> |
|---|---|
| To: | "Walker, Jed S" <Jed_Walker(at)cable(dot)comcast(dot)com> |
| Cc: | pgsql-novice(at)postgresql(dot)org |
| Subject: | Re: Handling Daylight Savings |
| Date: | 2005-08-04 20:34:03 |
| Message-ID: | 20050804203403.GA89957@winnie.fuhr.org |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-novice |
On Thu, Aug 04, 2005 at 01:54:39PM -0600, Walker, Jed S wrote:
> I am wondering how daylight savings is handled by PostgreSQL. We are
> timestamps with time zones, and are wondering if it's possible to
> specify a timezone as ET instead of EST or EDT. Do we have to know when
> daylight savings occurs and change our timezone settings on our own?
See "Date/Time Types" in the documentation for the version of
PostgreSQL you're using. Here's a link for the latest version:
http://www.postgresql.org/docs/8.0/static/datatype-datetime.html
PostgreSQL 8.0 comes with its own timezone database. Earlier
versions rely on whatever the operating system provides.
--
Michael Fuhr
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Frank Bax | 2005-08-04 21:04:50 | Re: Handling Daylight Savings |
| Previous Message | Walker, Jed S | 2005-08-04 20:20:35 | Re: using interval in a query with a column for the interval value? |