Bruce Momjian <[EMAIL PROTECTED]> writes:
> Tom Lane wrote:
>> The problem is that one of these two statements is using the abbrev
>> meaning and the other is using the timezone meaning.
> Is this a TODO?
We already fixed it:
2008-07-07 14:09 tgl
* src/backend/utils/adt/: date.c, times
Tom Lane wrote:
> Gregory Stark <[EMAIL PROTECTED]> writes:
> > ISTM this is the one that's wrong. "CET" is standard time, it, GMT+1.
>
> > If you want a timezone which switches between CET and CST automatically you
> > should use something like Europe/Paris.
>
> Well, actually he *is* using such
Gregory Stark <[EMAIL PROTECTED]> writes:
> ISTM this is the one that's wrong. "CET" is standard time, it, GMT+1.
> If you want a timezone which switches between CET and CST automatically you
> should use something like Europe/Paris.
Well, actually he *is* using such a zone:
regression=# select
Jaromír Talíř <[EMAIL PROTECTED]> writes:
> postgres# select '2008-06-01 10:10:10 UTC' AT TIME ZONE 'CET';
> timezone
> -
> 2008-06-01 12:10:10
ISTM this is the one that's wrong. "CET" is standard time, it, GMT+1.
If you want a timezone which switches between CET
First, if I do conversion from UTC to CET and back when a timestamp is
OUTSIDE of daylight saving period, it's correct:
postgres# select '2008-01-01 10:10:10 UTC' AT TIME ZONE 'CET';
timezone
-
2008-01-01 11:10:10
postgres# select '2008-01-01 11:10:10 CET' AT TIME
