Re: Re: Time AT TIME ZONE: false result using offset instead of time zone name

From: Adrian Klaver <adrian(dot)klaver(at)gmail(dot)com>
To: rawi <only4com(at)web(dot)de>, pgsql-sql(at)postgresql(dot)org
Subject: Re: Re: Time AT TIME ZONE: false result using offset instead of time zone name
Date: 2014-02-12 16:30:16
Message-ID: 52FBA198.1050001@gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-sql

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(dot)klaver(at)gmail(dot)com

In response to

Browse pgsql-sql by date

  From Date Subject
Next Message Adrian Klaver 2014-02-12 17:16:04 Re: Re: Time AT TIME ZONE: false result using offset instead of time zone name
Previous Message rawi 2014-02-12 15:29:56 Re: Time AT TIME ZONE: false result using offset instead of time zone name