I have four databases located all around the world and I would need a
function which will return GMT time.

Any tips?

Cheers
hh

On 9 Nov, 07:47, "Beginner" <begin... (AT) nospam (DOT) com> wrote:
What version of Oracle? What operating system? Are we talking client-
side? Server-side?

In the meantime: http://download.oracle.com/docs/cd/B...b14225/toc.htm

HTH

-g

Beginner wrote:
www.psoug.org
click on Morgan's Library
click on Built-in Functions just under the Google Search logo.
There are numerous functions that you could use to give you the
integer to perform the calculation.

But why not make it easy an just do the following:
ALTER SYSTEM SET TIME_ZONE = '-0:00';
--
Daniel A. Morgan
Oracle Ace Director & Instructor
University of Washington
damorgan@x.washington.edu (replace x with u to respond)
Puget Sound Oracle Users Group
www.psoug.org

On Nov 9, 6:49 am, gazzag <gar... (AT) jamms (DOT) org> wrote:
Beginner, if you are still using date data types instead of timezones
then the following might be of interest:

--
-- Convert between time zones
--
select to_char(sysdate,'YYYYMMDD HH24:MI:SS') as "Eastern Daylight"
,to_char(new_time(sysdate,'EDT','GMT'),'YYYYMMDD HH24:MI:SS')
GMT
from sys.dual
;

As mentioned the Oracle edition and version is always of interest.
The data type of the current data is also important.

HTH -- Mark D Powell --

DA Morgan wrote:

Because it will not work? ;-)
I guess you meant "alter database" but it is not always possible to use it
(e.g. with TIMESTAMP WITH LOCAL TIME ZONE columns.)
-----
échangez opinions et commentaires dans les forums de discussion.
http://www.usenetgratuit.com/