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

From will trillich
Subject Re: Determine Time in other Time Zone
Date
Msg-id 3AC2C0C4.E10106D5@serensoft.com
Whole thread Raw
In response to Re: Determine Time in other Time Zone  ("Russell Hires" <rhires@earthlink.net>)
List pgsql-general
Doug McNaught wrote:
>
> "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.

it SHOULD be simple, if you have access to what you need:

    -- convert originaltime to localtime:
    localTime = originalTime - originalTimeZone + localTimeZone

isn't there any quickie utility to deliver such variables? maybe at the
shell/scripting level? this is *nix, after all...

--
mailto:will@serensoft.com
http://www.dontUthink.com/

pgsql-general by date:

Previous
From: Sean Harding
Date:
Subject: full table scan on 'select max(value) from table'?
Next
From: "Randall F. Kern"
Date:
Subject: RE: full table scan on 'select max(value) from table'?