From: Scott Marlowe <scott.marlowe@gmail.com>
To: Fernando Hevia <fhevia@ip-tel.com.ar>
Cc: SQL Postgresql List <pgsql-sql@postgresql.org>
Subject: Re: PG is in different timezone than the OS
Date: Wed, 2 Jan 2008 14:27:07 -0600
Message-ID: <dcc563d10801021227h15e36570qbbb55e3b7a1d72ef@mail.gmail.com> (raw)
In-Reply-To: <dcc563d10801021206m24c23294m49d9855ddd670a73@mail.gmail.com>
References: <00ff01c84d6f$65e64ec0$8f01010a@iptel.com.ar>
<dcc563d10801021206m24c23294m49d9855ddd670a73@mail.gmail.com>
Carrying on a convo with myself here.
Looking in the timezone directory, and looking at the tz database
located at ftp://elsie.nci.nih.gov/pub/ it appears the southamerica
timezone data was updated 2007-12-13 at 9am or so. Looking through
the file it looks like the change was made:
# From Steffen Thorsen (2007-12-21):
# A user (Leonardo Chaim) reported that Argentina will adopt DST....
# all of the country (all Zone-entries) are affected. News reports like
# http://www.lanacion.com.ar/opinion/nota.asp?nota_id=973037 indicate
# that Argentina will use DST next year as well, from October to
# March, although exact rules are not given.
#
# From Jesper Norgaard Welen (2007-12-26)
# The last hurdle of Argentina DST is over, the proposal was approved in
# the lower chamber too (Deputados) with a vote 192 for and 2 against.
# By the way thanks to Mariano Absatz and Daniel Mario Vega for the link to
# the original scanned proposal, where the dates and the zero hours are
# clear and unambiguous...This is the article about final approval:
# <a href="http://www.lanacion.com.ar/politica/nota.asp?nota_id=973996";
# http://www.lanacion.com.ar/politica/nota.asp?nota_id=973996
# </a>
#
# From Paul Eggert (2007-12-22):
# For dates after mid-2008, the following rules are my guesses and
# are quite possibly wrong, but are more likely than no DST at all.
Rule Arg 2007 only - Dec 30 0:00 1:00 S
Rule Arg 2008 max - Mar Sun>=15 0:00 0 -
Rule Arg 2008 max - Oct Sun>=1 0:00 1:00 S
So, it appears that the timezone folks know...
Note that I added pgsql-general, as this isn't really a -sql question.
Next person to reply please remove the -sql group.
Reply instructions:
You may reply publicly to this message via plain-text email
using any one of the following methods:
* Reply to all the recipients using the --to and --cc options:
reply via email
To: pgsql-sql@postgresql.org
Cc: scott.marlowe@gmail.com, fhevia@ip-tel.com.ar
Subject: Re: PG is in different timezone than the OS
In-Reply-To: <dcc563d10801021227h15e36570qbbb55e3b7a1d72ef@mail.gmail.com>
* Save the following mbox file, import it into your mail client,
and reply-to-all from there: mbox
This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox