Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.server -> Re: Timezone Problem

Re: Timezone Problem

From: Andy Hassall <andy_at_andyh.co.uk>
Date: Tue, 20 Dec 2005 16:17:27 +0000
Message-ID: <nhbgq15sevvdgga39ocnm0j7nggcaflq2h@4ax.com>


On Tue, 20 Dec 2005 16:12:56 +0100, "Robert Klemme" <bob.news_at_gmx.net> wrote:

>Björn Wächter wrote:
>>
>> - GMT is UTC so the offset is 0
>> - US/Eastern is in the west of London (UTC) so the result is negative
>> - Berlin is in the East of London(UTC) so the result is positive
>> - GMT+1 has a result of -01:00 but this indicates it is 1 hour in the
>> west of London like Atlantic/Azores. But GMT+1 is the Timezone of
>> Berlin. The Timezone of the Azores is GMT-1.
>> See:
>> http://www.timeanddate.com/worldclock/city.html?n=271
>>
>> So why Is the offset of the Azores and GMT+1 the same?
>
>We ran into this just the other day. Although I can't back this with
>evidence here's our theory: we guess there is an old naming convention
>that used GMT+n to denote a time zone that is n hours after GMT.

 Yes, it's the POSIX standard that defines this:

http://www.opengroup.org/onlinepubs/009695399/basedefs/xbd_chap08.html

 See the definition of the "TZ" variable, and look at "offset".

-- 
Andy Hassall :: andy@andyh.co.uk :: http://www.andyh.co.uk
http://www.andyhsoftware.co.uk/space :: disk and FTP usage analysis tool
Received on Tue Dec 20 2005 - 10:17:27 CST

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US