Upon further review... :-)
I had a look at the ntp website, and there is a bunch of links at the
bottom. http://www.eecis.udel.edu/~ntp/ is the main ntp page.
http://www.bsdi.com/date/date?PRC is pretty interesting. It appears that
someone has already figured out the time in the various timezones! How you
could link this into a database I don't know...Maybe you could add an entry
for each user that would incorporate their location based on the list on
that web page.
I then went a-lookin' for more info on this. www.timezoneconverter.com was
looking interesting. It contains cgi-bin info (unforunately, hidden from
view). There was also a list of routines at ftp://elsie.nci.nih.gov/pub/ and
instructions at http://sandbox.xerox.com/stewart/tzconvert.cgi/info#help
Okay, enough research (Phew! I'm tired...). Is any of this useful? How could
it be incorporated into PSQL? I assume it's possible to call outside
routines from PSQL.
Hope this helps,
Russell
____________________________________________________
_its_ (no apostrophe) means "the thing that it owns"
_it's_ (with apostrophe) means "it is"
----------
>From: Doug McNaught <doug@wireboard.com>
>To: "Russell Hires" <rhires@earthlink.net>
>Cc: will trillich <will@serensoft.com>, pgsql-general@postgresql.org
>Subject: Re: [GENERAL] Determine Time in other Time Zone
>Date: Wed, Mar 28, 2001, 10:12 PM
>
> "Russell Hires" <rhires@earthlink.net> writes:
>
>> Second, perhaps this sort of problem has been solved via the ntp software?
>> ntp polls various time servers. Perhaps there is a way to call a timeserver
>> that is local to where ever the users are logging in from.
>
> NTP keeps time in UTC. Translation into local time is the
> responsibility of the client. So that won't help much.
>
> Translating times between time zones is a hard problem. One thing to
> look at is the timezone code that is shipped with free Unices
> (BSD/Linux) as it comes with a database of timezones with their
> offsets and DST rules.
>
> -Doug
>
> ---------------------------(end of broadcast)---------------------------
> TIP 6: Have you searched our list archives?
>
> http://www.postgresql.org/search.mpl
