Re: Determine Time in other Time Zone

On Fri, Mar 09, 2001 at 07:18:00PM -0700, Marc Wrubleski wrote:
> I need to determine the users time in another Time Zone for the
> time now().
>
> I tried to manually add or subtract the difference of hours
> between the server timezone and the other timezone, but I have
> to do it for _Every_ timezone. Not only that, but I need to
> take Daylight Saving Time (DST) into account for those
> timezones that use it.
>
> I have tried the timezone(text,timestamp) function, but for
> that to work with daylight savings time I need to know whether
> the DST is being applied for this date. Ie I have to give the
> function either MST or MDT, and I don't know how to switch it
> based on now() and the timezone.
>
> I know that I can set the postgres timezone to a timezone
> defined within Linux's /usr/share/zoneinfo, and that adjusts
> the local time properly including DST.
>
> What I want is a way to ask for the time in a different time
> zone and use the Linux zoneinfo to calculate it.
>
> Does anyone know have an idea how I can solve this problem?
> Would anyone else be able to use this functionality?

did you ever get a response on this? it looks interesting and
useful...

--
will(at)serensoft(dot)com
http://newbieDoc.sourceforge.net/ -- we need your brain!
http://www.dontUthink.com/ -- your brain needs us!