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/
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! |