Postgres Pro
Downloads
Home   >   mailing lists

Thread: Time zone 'GMT+8'

Time zone 'GMT+8'

From
seiliki@so-net.net.tw
Date:
The target pgsql is compiled from 8.4rc1. 'GMT+8' can be found in installed binary file
.../share/postgresql/timezone/Etc/GMT+8.

This is the recorded script:

-----BEGIN record----------
db1=# select now();
              now
-------------------------------
 2009-11-29 14:44:37.322414+08
(1 row)

db1=# set timezone to 'GMT+8';
SET
db1=# select now();
              now
-------------------------------
 2009-11-28 22:45:03.397545-08
(1 row)

db1=# set timezone to GMT-8';
SET
db1=# select now();
              now
-------------------------------
 2009-11-29 14:45:39.160701+08
(1 row)

db1=# set timezone to '0';
SET
db1=# select now();
              now
-------------------------------
 2009-11-29 06:45:54.347482+00
(1 row)
-----END record----------

I thought time zone 'GMT+8'  was '8' or UTC+8, and 'GMT-8' was '-8' or UTC-8. Does the original time zone settings
shippedwith source have special interpretation that is different from my understanding? 

Regards,
CN

Re: Time zone 'GMT+8'

From
silly8888
Date:
From http://www.postgresql.org/docs/current/static/datatype-datetime.html#DATATYPE-TIMEZONES

Another issue to keep in mind is that in POSIX time zone names,
positive offsets are used for locations west of Greenwich.




On Sun, Nov 29, 2009 at 2:08 AM,  <seiliki@so-net.net.tw> wrote:
> The target pgsql is compiled from 8.4rc1. 'GMT+8' can be found in installed binary file
.../share/postgresql/timezone/Etc/GMT+8.
>
> This is the recorded script:
>
> -----BEGIN record----------
> db1=# select now();
>              now
> -------------------------------
>  2009-11-29 14:44:37.322414+08
> (1 row)
>
> db1=# set timezone to 'GMT+8';
> SET
> db1=# select now();
>              now
> -------------------------------
>  2009-11-28 22:45:03.397545-08
> (1 row)
>
> db1=# set timezone to GMT-8';
> SET
> db1=# select now();
>              now
> -------------------------------
>  2009-11-29 14:45:39.160701+08
> (1 row)
>
> db1=# set timezone to '0';
> SET
> db1=# select now();
>              now
> -------------------------------
>  2009-11-29 06:45:54.347482+00
> (1 row)
> -----END record----------
>
> I thought time zone 'GMT+8'  was '8' or UTC+8, and 'GMT-8' was '-8' or UTC-8. Does the original time zone settings
shippedwith source have special interpretation that is different from my understanding? 
>
> Regards,
> CN
>
> --
> Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
> To make changes to your subscription:
> http://www.postgresql.org/mailpref/pgsql-general
>

Re: Time zone 'GMT+8'

From
Martin Gainty
Date:
there are 3 terms which refer to GMT
GMT in the UK
Zulu time for aviators
UTC for Scientific measurements

UTC is now replacing 'Zulu' and 'GMT' for 0 time references

http://wwp.greenwichmeantime.com/info/zulu.htm
Martin Gainty
______________________________________________
Verzicht und Vertraulichkeitanmerkung/Note de déni et de confidentialité
 
Diese Nachricht ist vertraulich. Sollten Sie nicht der vorgesehene Empfaenger sein, so bitten wir hoeflich um eine Mitteilung. Jede unbefugte Weiterleitung oder Fertigung einer Kopie ist unzulaessig. Diese Nachricht dient lediglich dem Austausch von Informationen und entfaltet keine rechtliche Bindungswirkung. Aufgrund der leichten Manipulierbarkeit von E-Mails koennen wir keine Haftung fuer den Inhalt uebernehmen.
Ce message est confidentiel et peut être privilégié. Si vous n'êtes pas le destinataire prévu, nous te demandons avec bonté que pour satisfaire informez l'expéditeur. N'importe quelle diffusion non autorisée ou la copie de ceci est interdite. Ce message sert à l'information seulement et n'aura pas n'importe quel effet légalement obligatoire. Étant donné que les email peuvent facilement être sujets à la manipulation, nous ne pouvons accepter aucune responsabilité pour le contenu fourni.





> Date: Sun, 29 Nov 2009 15:08:01 +0800
> From: seiliki@so-net.net.tw
> To: pgsql-general@postgresql.org
> Subject: [GENERAL] Time zone 'GMT+8'
>
> The target pgsql is compiled from 8.4rc1. 'GMT+8' can be found in installed binary file .../share/postgresql/timezone/Etc/GMT+8.
>
> This is the recorded script:
>
> -----BEGIN record----------
> db1=# select now();
> now
> -------------------------------
> 2009-11-29 14:44:37.322414+08
> (1 row)
>
> db1=# set timezone to 'GMT+8';
> SET
> db1=# select now();
> now
> -------------------------------
> 2009-11-28 22:45:03.397545-08
> (1 row)
>
> db1=# set timezone to GMT-8';
> SET
> db1=# select now();
> now
> -------------------------------
> 2009-11-29 14:45:39.160701+08
> (1 row)
>
> db1=# set timezone to '0';
> SET
> db1=# select now();
> now
> -------------------------------
> 2009-11-29 06:45:54.347482+00
> (1 row)
> -----END record----------
>
> I thought time zone 'GMT+8' was '8' or UTC+8, and 'GMT-8' was '-8' or UTC-8. Does the original time zone settings shipped with source have special interpretation that is different from my understanding?
>
> Regards,
> CN
>
> --
> Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
> To make changes to your subscription:
> http://www.postgresql.org/mailpref/pgsql-general

Hotmail: Trusted email with powerful SPAM protection. Sign up now.

Re: Time zone 'GMT+8'

From
Tom Lane
Date:
silly8888 <silly8888@gmail.com> writes:
>> From http://www.postgresql.org/docs/current/static/datatype-datetime.html#DATATYPE-TIMEZONES

> Another issue to keep in mind is that in POSIX time zone names,
> positive offsets are used for locations west of Greenwich.

Yeah, we're caught between two incompatible conventions :-(.  I suggest
reading the whole section linked to above, it should make things
clearer.

            regards, tom lane