Re: [GENERAL] Time zone 'GMT+8'

2009-11-29 Thread Tom Lane
silly 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 convent

Re: [GENERAL] Time zone 'GMT+8'

2009-11-29 Thread Martin Gainty
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 Vertrau

Re: [GENERAL] Time zone 'GMT+8'

2009-11-28 Thread silly8888
>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, wrote: > The target pgsql is compiled fr