Re: Handling Daylight Savings

At 04:34 PM 8/4/05, Michael Fuhr wrote:

>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.


How is the actual date of change handled for each spring/fall change?  Is
the "timezone database" configurable by year?  What happens if proposed
changes to DST effective dates in North America are adopted?