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
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: seil...@so-net.net.tw > To: pgsql-general@postgresql.org > Subject: [GENERAL] Time zone 'GMT+8'

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

[GENERAL] Time zone 'GMT+8'

2009-11-28 Thread seiliki
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.32241