Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.misc -> Re: Need a function to return GMT time

Re: Need a function to return GMT time

From: Mark D Powell <Mark.Powell_at_eds.com>
Date: Fri, 09 Nov 2007 14:47:07 -0800
Message-ID: <1194648427.296472.264210@57g2000hsv.googlegroups.com>


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 --
Received on Fri Nov 09 2007 - 16:47:07 CST

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US