Re: Need a function to return GMT time

On Nov 9, 6:49 am, gazzag <gar..._at_jamms.org> wrote:
> On 9 Nov, 07:47, "Beginner" <begin..._at_nospam.com> 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
>
> What version of Oracle? What operating system? Are we talking client-
> side? Server-side?
>
> In the meantime:http://download.oracle.com/docs/cd/B19306_01/server.102/b14225/toc.htm
>
> HTH
>
> -g

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 --