Re: Need a function to return GMT time

Beginner wrote:
> I have four databases located all around the world and I would need a
> function which will return GMT time.
>
> Any tips?
>
> Cheers
> hh

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_at_x.washington.edu (replace x with u to respond)
Puget Sound Oracle Users Group
www.psoug.org