I am baffled. Both PDT and WEST appear as valid timezone abbreviations, and
each have unique values, but:
test=# select timestamp with time zone '2011-09-29 18:00 PDT';
timestamptz
2011-09-29 18:00:00-07
(1 row)
test=# select timestamp with time zone
On 09/29/11 10:17 AM, Christophe Pettus wrote:
Both PDT and WEST appear as valid timezone abbreviations...
WEST? Really? where does this appear, I've never seen that.
--
john r pierceN 37, W 122
santa cruz ca mid-left coast
--
Sent via
Christophe Pettus x...@thebuild.com writes:
I am baffled. Both PDT and WEST appear as valid timezone abbreviations, and
each have unique values, but:
Where do you see WEST as a valid timezone abbrevation? It's not listed
in the Default abbreviation list. (Perhaps it should be, since there
On Sep 29, 2011, at 10:50 AM, Tom Lane wrote:
Christophe Pettus x...@thebuild.com writes:
I am baffled. Both PDT and WEST appear as valid timezone abbreviations, and
each have unique values, but:
Where do you see WEST as a valid timezone abbrevation?
Voila, Western Europe Summer Time:
On 09/29/2011 10:50 AM, Tom Lane wrote:
Christophe Pettusx...@thebuild.com writes:
I am baffled. Both PDT and WEST appear as valid timezone abbreviations, and
each have unique values, but:
Where do you see WEST as a valid timezone abbrevation? It's not listed
in the Default abbreviation
On 09/29/11 11:44 AM, Steve Crawford wrote:
There are 56 records and 3 different offsets in pg_timezone_names for
the abbreviation 'CST'.
yeah, we had some internal java software crashing on CST when it was
deployed in China :-/
I suggested the developer switch to using ISO format, and the
On Sep 29, 2011, at 11:44 AM, Steve Crawford wrote:
There are 56 records and 3 different offsets in pg_timezone_names for the
abbreviation 'CST'.
That's actually how this popped up for me; using 'IST' was giving rather
unexpected results...
--
-- Christophe Pettus
x...@thebuild.com
--
Christophe Pettus x...@thebuild.com writes:
That's actually how this popped up for me; using 'IST' was giving rather
unexpected results...
IST is one of the ones where there's a real conflict, ie it means
different things to different people. That was what drove us to invent
the timezone
On Sep 29, 2011, at 12:11 PM, Tom Lane wrote:
IST is one of the ones where there's a real conflict, ie it means
different things to different people.
Indeed; just noting that the search for a non-conflicting abbreviation is what
lead me to find the WEST thing.
--
-- Christophe Pettus
Steve Crawford scrawf...@pinpointresearch.com writes:
Actually, given that pg_timezone_abbrevs is based on the
timezone_abbreviations GUC, I'm not surprised that it is a subset of
what is in pg_timezone_names. But I am a bit surprised that the opposite
is true.
For zones that observe DST,
On 09/29/2011 11:44 AM, Steve Crawford wrote:
But 61 abbreviations that appear in pg_timezone_names do not have a
corresponding entry in pg_timezone_abbrevs and 69 abbreviations in
pg_timezone_abbrevs that don't appear in pg_timezone_names.
Actually, given that pg_timezone_abbrevs is
11 matches
Mail list logo