Re: Determine Time in other Time Zone
От | will trillich |
---|---|
Тема | Re: Determine Time in other Time Zone |
Дата | |
Msg-id | 3AC2C0C4.E10106D5@serensoft.com обсуждение исходный текст |
Ответ на | Re: Determine Time in other Time Zone ("Russell Hires" <rhires@earthlink.net>) |
Список | 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 по дате отправления: