Re: DATE with time zones

From: Robert Klemme <bob.news_at_gmx.net>
Date: Fri, 28 Oct 2005 17:24:30 +0200
Message-ID: <3seu5iFnkhqfU1@individual.net>

Mark D Powell wrote:
> Robert, you could write your own version of new_time that handles the
> missing (newer) time zones found in v$timezone_names. If you create a
> table assigning each TZ from v$timezone_names its offset from UDT
> (formerly GMT) then you could perform the conversion with a little
> math.

This has been suggested as solution for SQL Server already, the only problem being that "little" is not the appropriate term. "complex" would be better. In fact, the suggested solution involves a table that stores this information (including DST times). This is quite some effort...

Kind regards

robert Received on Fri Oct 28 2005 - 10:24:30 CDT