Re: Determine Time in other Time Zone

From: will trillich <will(at)serensoft(dot)com>
To:
Cc: pgsql-general(at)postgresql(dot)org
Subject: Re: Determine Time in other Time Zone
Date: 2001-03-29 04:57:40
Message-ID: 3AC2C0C4.E10106D5@serensoft.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

Doug McNaught wrote:
>
> "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.

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(at)serensoft(dot)com
http://www.dontUthink.com/

In response to

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Randall F. Kern 2001-03-29 04:59:53 RE: full table scan on 'select max(value) from table'?
Previous Message Maurizio Ortolan 2001-03-29 04:50:56 Error in the date field (with NULL value...).Thanks!