Received: from malur.postgresql.org ([217.196.149.56])
 by arkaria.postgresql.org with esmtp (Exim 4.80) (envelope-from
 <pgsql-sql-owner+M37658=pgsql+2Dsql=arkaria.postgresql.org@postgresql.org>)
 id 1WDchX-0004RE-CL
 for pgsql-sql@arkaria.postgresql.org; Wed, 12 Feb 2014 16:30:19 +0000
Received: from localhost ([127.0.0.1] helo=postgresql.org)
 by malur.postgresql.org with smtp (Exim 4.80) (envelope-from
 <pgsql-sql-owner+M37658=pgsql+2Dsql=arkaria.postgresql.org@postgresql.org>)
 id 1WDchW-0003Os-Sa
 for pgsql-sql@arkaria.postgresql.org; Wed, 12 Feb 2014 16:30:18 +0000
Received: from makus.postgresql.org ([2001:4800:7903:4::125])
 by malur.postgresql.org with esmtp (Exim 4.80)
 (envelope-from <adrian.klaver@gmail.com>) id 1WDchW-0003Oc-4I
 for pgsql-sql@postgresql.org; Wed, 12 Feb 2014 16:30:18 +0000
Received: from mail-pd0-x22d.google.com ([2607:f8b0:400e:c02::22d])
 by makus.postgresql.org with esmtp (Exim 4.80)
 (envelope-from <adrian.klaver@gmail.com>) id 1WDchS-0008TF-D8
 for pgsql-sql@postgresql.org; Wed, 12 Feb 2014 16:30:17 +0000
Received: by mail-pd0-f173.google.com with SMTP id y10so9208859pdj.32
 for <pgsql-sql@postgresql.org>; Wed, 12 Feb 2014 08:30:13 -0800 (PST)
DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=gmail.com; s=20120113;
 h=message-id:date:from:user-agent:mime-version:to:subject:references
 :in-reply-to:content-type:content-transfer-encoding;
 bh=G0wTngjDGNqcGO7leqek4eAs0lmBV4iVC9s3auQrr6I=;
 b=EnsjzHFHUtd5TZMNn6x76cSRp1N1kmLe3+WGtI+VBcgiDFbqwNYznnpXaRe2Nnn9n6
 mBLijZbDTs6cbioZJ+9KqTi2Xrl3UiqwiZu42cuNy0LvLTQQNbrz2zxEF3pI69xcdT/V
 V9Pq+/rry/9Ef2qAYNP/DeCClXA0TgaR7J0gSaUoOjfIwCIuhnlor/4hkBqNwqhPA3NK
 cN0lwUcXXq/WMuc+dEFWX0SiNWdjdHRL0L/rEQOkZS2IxJ9yl5E1mtLq49avv750yY/w
 ZbVza1Kqf9Puh8hF6Lc2EJFc969WLgOQ6Q6tD79gdIimnMlz3K8LjMdIP/PpMW926RyO
 xGsQ==
X-Received: by 10.68.111.65 with SMTP id ig1mr52504140pbb.3.1392222612977;
 Wed, 12 Feb 2014 08:30:12 -0800 (PST)
Received: from killi.site (173-160-167-74-Washington.hfc.comcastbusiness.net.
 [173.160.167.74])
 by mx.google.com with ESMTPSA id id1sm65082465pbc.11.2014.02.12.08.30.11
 for <multiple recipients>
 (version=TLSv1 cipher=ECDHE-RSA-RC4-SHA bits=128/128);
 Wed, 12 Feb 2014 08:30:12 -0800 (PST)
Message-ID: <52FBA198.1050001@gmail.com>
Date: Wed, 12 Feb 2014 08:30:16 -0800
From: Adrian Klaver <adrian.klaver@gmail.com>
User-Agent: Mozilla/5.0 (X11; Linux x86_64;
 rv:24.0) Gecko/20100101 Thunderbird/24.3.0
MIME-Version: 1.0
To: rawi <only4com@web.de>, pgsql-sql@postgresql.org
Subject: Re: Re: Time AT TIME ZONE: false result using offset instead
 of time zone name
References: <1392105285704-5791371.post@n5.nabble.com>
 <52FA3499.3020604@gmail.com> <1392193455856-5791556.post@n5.nabble.com>
 <52FB8D48.6010805@gmail.com> <1392218996355-5791602.post@n5.nabble.com>
In-Reply-To: <1392218996355-5791602.post@n5.nabble.com>
Content-Type: text/plain; charset=ISO-8859-1; format=flowed
Content-Transfer-Encoding: 7bit
X-Pg-Spam-Score: -2.0 (--)
List-Archive: <http://archives.postgresql.org/pgsql-sql>
List-Help: <mailto:majordomo@postgresql.org?body=help>
List-ID: <pgsql-sql.postgresql.org>
List-Owner: <mailto:pgsql-sql-owner@postgresql.org>
List-Post: <mailto:pgsql-sql@postgresql.org>
List-Subscribe: <mailto:majordomo@postgresql.org?body=sub%20pgsql-sql>
List-Unsubscribe: <mailto:majordomo@postgresql.org?body=unsub%20pgsql-sql>
X-Mailing-List: pgsql-sql
Precedence: bulk
Sender: pgsql-sql-owner@postgresql.org

On 02/12/2014 07:29 AM, rawi wrote:
> Adrian Klaver-3 wrote
>> Welcome to the wacky world of time, it is all relative:) The choices are
>> handle everything as UTC until you present to the end user or use actual
>> timezones, for example, America/Los_Angeles. To illustrate, in your
>> original post you said:
>>
>> "But it would be easier to ask a specific time offset (got from a client
>> around the world), so for me +01 hour"
>>
>> Do you know if that offset supplied by the client was POSIX or ISO in
>> its sign?
>
> The (playing) question was: how would I get the time zone of a browser
> somewhere unknown on earth?
>
> And the found javascript solution would return the difference between GMT
> and localtime in minutes, so for me west from Greenwich a negative integer.
>
> Please save the following in a html file eg. "time_offset.html" and load it
> in your browser:


I do not see the code, so I can not test.

>
>
>
>
>



-- 
Adrian Klaver
adrian.klaver@gmail.com


-- 
Sent via pgsql-sql mailing list (pgsql-sql@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-sql