Re: Determine Time in other Time Zone

From: Doug McNaught <doug(at)wireboard(dot)com>
To: "Russell Hires" <rhires(at)earthlink(dot)net>
Cc: will trillich <will(at)serensoft(dot)com>, pgsql-general(at)postgresql(dot)org
Subject: Re: Determine Time in other Time Zone
Date: 2001-03-29 03:12:48
Message-ID: m37l19s1xr.fsf@belphigor.mcnaught.org
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

"Russell Hires" <rhires(at)earthlink(dot)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

In response to

Responses

Browse pgsql-general by date

  From Date Subject
Next Message will trillich 2001-03-29 04:27:36 Re: explain shows lots-o-preliminary sorting
Previous Message Russell Hires 2001-03-29 03:06:03 Re: Determine Time in other Time Zone