Re: [HACKERS] Need confirmation of "Posix time standard" on FreeBSD

From: Thomas Lockhart <lockhart(at)alumni(dot)caltech(dot)edu>
To: Malcolm Beattie <mbeattie(at)sable(dot)ox(dot)ac(dot)uk>
Cc: pgsql-hackers(at)postgreSQL(dot)org
Subject: Re: [HACKERS] Need confirmation of "Posix time standard" on FreeBSD
Date: 2000-02-08 18:24:44
Message-ID: 38A05F6C.B2C42E8B@alumni.caltech.edu
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-hackers

> > Thanks for the info. How do they define "the standard time zone"? Is
> > it *any* time zone, or "GMT", or some other set of choices?
> It's "standard" in the sense of not-summer/not-daylight-savings rather
> than in the "POSIX compliance" sense. In other words, std can be any
> three bytes you like subject to the not-leading-colon, not-digits etc.
> constraints above. Later in the section it says that summer time is
> assumed to be one hour ahead of standard time if no offset follows
> dst. Also,
> If [an offset is] preceded by a "-"; the time zone shall be east of
> the Prime Meridian; otherwise it shall be west (which may be
> indicated by an optional preceding "+").
> That's the bit which shows that the "+" is OK. Aha, but I've just
> looked back at your original message and it refers to "GMT+0800"
> whereas POSIX requires a ":" between the hours and minutes. So in
> fact, "GMT+0800" is *not* legal and it should be "GMT+08:00" or
> "GMT+08" or "GMT+8" (single digit hours are allowed).

OK. I'll need to generalize the current code, which looks specifically
for "gmt". Possibly, we'll have just the "GMT+/-####" case handled for
7.0, but if I get time.

And we'll allow a superset of the Posix standard, so "GMT+0800" will
be legal (otherwise, it would disallow the ISO8601 standard which imho
should take precedence).

- Thomas

--
Thomas Lockhart lockhart(at)alumni(dot)caltech(dot)edu
South Pasadena, California

In response to

Responses

Browse pgsql-hackers by date

  From Date Subject
Next Message Mark Hollomon 2000-02-08 18:59:35 Re: [HACKERS] docs and createlang patch for plperl
Previous Message Thomas Lockhart 2000-02-08 18:17:41 Re: [HACKERS] Deferred trigger queue