Re: Determine Time in other Time Zone - Mailing list pgsql-general

From Doug McNaught
Subject Re: Determine Time in other Time Zone
Date
Msg-id m37l19s1xr.fsf@belphigor.mcnaught.org
Whole thread Raw
In response to Re: Determine Time in other Time Zone  ("Russell Hires" <rhires@earthlink.net>)
List pgsql-general
"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

pgsql-general by date:

Previous
From: "Russell Hires"
Date:
Subject: Re: Determine Time in other Time Zone
Next
From: will trillich
Date:
Subject: Re: explain shows lots-o-preliminary sorting