DATE with time zones

From: Robert Klemme <bob.news_at_gmx.net>
Date: Wed, 26 Oct 2005 14:12:01 +0200
Message-ID: <3s9a4kFmqvj6U1@individual.net>

Folks,

since Ora 9 we have data type TIMESTAMP with serveral variants. Now, if I want to output times in a user's timezone I just choose TIMESTAMP WITH LOCAL TIME ZONE use ALTER SESSION SET TIME_ZONE='PST' and be happy.

Unfortunately we have large data sets which use DATE (historic and space reaons). Now, does anybody have an idea how I can emulate the behavior of TIMESTAMP WITH LOCAL TIME ZONE with DATE which does not involve copying data around into a new table? As it stands, DATE output is completely unaffected by the session's time zone.

Thankful for any ideas, hints...

Kind regards

robert Received on Wed Oct 26 2005 - 07:12:01 CDT